For loop can be used to setup a loop to selecting all CSV’s in particular location based on a pattern like C:App*.csv for all files starting with App in their name in C Drive root Folder.
This can be achieved by using following steps:
3. Drag a DataFlow task and set the FlatFile connection connecting any of the files in that location.
4. Now change connection manager properties in Expressions to use the connection string using the variable created above.
5. Perform transformations and load into destination.
Now, say you have one file which does not match the same columns or invalid. So, you want the execution not to stop on error.
This can be achieved by using event Handler on DataFlow Task Forloop and making propagate on error to False as shown below: