A much more simple solution than looping is to use the "Multi Flat File Connection" in your Connection Managers. If you right-click in the Connection Managers section and select New Connection it is in the list. You can point it to a directory and wildcard your file name such as *.CSV and then import all the files matching the criteria. The example provided is a much more granular approach and has its merits, but if you are looking to simply import a set of CSV files in one swoop try this alternative.
Kendall
ohh Thanks Kendall, even when I did not know that method (i learned something new today), my objective was to show how the ForEachLoop Container works, and i tought the bulk insert task is one of the simplest examples i could make to not complicate the tutorial with weird data flow tasks...
but thanks for the tip! i will give it a try!
You did a great job demonstrating the ForEachLoop; In fact I bookmarked the article as "ForEachLoop Example" in my SQL favorites folder. No disrespect or minimization of your article intended and I apologize if it came off as such.