This seems very simple but I'm drawing a blank...
I want start up an SSIS 2005 package and first check a collection of subfolders within a main folder to see if any clients have uploaded any files into any of these subfolders. I don't initially care about any file names. I just want to know if within several subfolders within a main folder if there is at least 1 file present. If there's at least 1 file present, then I want to move forward with the ETL process specified in my package.
I have this so far and there are tons of files within the subfolders contained within my main folder here but the fi.Length is constantly returning 0.
Public Sub Main()
Dim sSourceFolder As String
sSourceFolder = Dts.Variables("SourceFolder").Value.ToString
Dim di As DirectoryInfo = New DirectoryInfo(sSourceFolder)
Dim fi As FileInfo() = di.GetFiles("*.*")
If fi.Length > 0 Then
Dts.Variables("User::isFileExists").Value = True
Dts.Variables("User::isFileExists").Value = False
Dts.TaskResult = Dts.Results.Success
Any suggestions where I'm going wrong here?