April 2, 2014 at 8:31 pm
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
Else
Dts.Variables("User::isFileExists").Value = False
End If
Dts.TaskResult = Dts.Results.Success
End Sub
Any suggestions where I'm going wrong here?
April 2, 2014 at 10:07 pm
Such code is a little out of my league but I don't see where you're drilling down past the main folder at all.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 3, 2014 at 12:15 am
Jeff is correct.
If there are no files in the main folders (except subfolders), you will get the 0 as a result.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply