I looked at the example you referenced and downloaded the sample file the author provided but its still not clear. What I rally need is an on line sample/example walk-thru that takes you step by step thru every click and setting you gott ado, assuming absolutely nothing, on how to add a ForEachLoop to an existing flat file import where the destination is a Dtabase table.
Know of anything like that?
I thought that link would give you a good start on SSIS... with the help of import/export wizard were you able to build the part where you can load the data from a file to a table? If so, just save the package and open the package with BIDS... You will see a DATA FLOW TASK in the CONTROL FLOW.. All you need to do is drag and drop the FOR EACH LOOP container to the Empty space and FOLLOW THE STEPS IN THE LINK and then drag the DATA FLOW TASK that you created into the FOR EACH LOOP ...
IT'S THAT EASY!!!
STEP 1:
Example 1: This link describes on how to Import data from File to OLE DB destination Table... You just need to omit the part where the author Creates a Table in link 2 because you already have one....
http://www.sqlyoga.com/2009/10/sql-server-ssis-basic-example-of-data.html]
STEP 2: create a FOR EACH LOOP and change the Directory path and File Type and then create a variable and change connection properties as it describes in the link below
http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx]
If you still have trouble just stick in the screenshots along with the error