SSIS Package: Get count of files in folder and exit if 0
I have a for each file loop in my SSIS Package that works fine
What I need to do is get a count of files in this folder
C:\EW\FTP\Breckenridge\Rol
If > 0 Then proceed with for each
If = 0
Exit process.
What I need to do is get a count of files in this folder
C:\EW\FTP\Breckenridge\Rol
If > 0 Then proceed with for each
If = 0
Exit process.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I didn't use SSIS these days... but technically you can run a Script Task in which you can write your own C# code to get the file count