asked
For each loop enumerator in SSIS
I am using ForEach loop container to read files from a source folder .before execution there are two files in the folder but at run time another file is dumped to the same folder. I want that file should also be read within that execution process. So please tell me the method to implement the same using SSIS.
You need to ensure that in the Collection tab of the Foreach Loop Editor that under Files you select *.* and not explicitly select the filename or type of file. That should do it.
It sounds like the files are being copied before the new file is in the directory. I would suggest you run the package one step at a time to see exactly what's going on.
once the package execution is started, it will go through the number of files so the files which are being added at the time of execution will be ignored.
I would go by a For Loop Container which will loop until a variable is set to fale (in the beginning true). Then having another variable with list of processed files and variable of files to process. With each loop of the For Loop Container you could use the script task to dump the list of files in the directory. Then the files not contained in the list of processed files, you add to the processed files and also to the list of files to be processed. If the list of files to be processed is empty, the variable to control the For Loop Container will be set to False to exit the loop execution. Next action will be a ForEach loop to process the list of files to be processed. ![alt text][1] [1]: /upfiles/Loop.png
Here is the example that Helped me accomplish this.
http://www.mssqltips.com/sqlservertip/2874/loop-through-flat-files-in-sql-server-integration-services/
1 Person is following this question.
