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