This answer explains how to to loop over multiple flat files and insert them into seperate SQL Server tables.