The Multiple Flat File Connection manager in SQL Server Integration Services allows users to import multiple files using a single connection manager. Using the “*” wildcard also enables all files within a directory to be easily imported.This video demonstrates how to configure a multiple flat files connection manager.
Hi I watched your video and thought I might help me… My issue is I need to load 100s of 1000s of small files that are all the same. Could the multi flat file connection handle that..??
Hi Apologies for the slow response. Your comment got directed to my spam folder. Yes – the multi flat file is an option. The other approach, which is more complicated, is to use some looping logic.Here are a couple of links for the “for each loop” approach.
http://stackoverflow.com/questions/7411741/looping-through-excel-files-and-tables-in-ssis-using-foreach-loop-containers
http://msdn.microsoft.com/en-us/library/ms345182.aspx