ssis Using loop control to run a dataflow task for every file.


If you want to check the existence of one file or do a couple of actions for every file in a folder you can use the Foreach Loop Container.

You give the path and the file mask and it will run it for every file it finds

For each file enumerator