InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 18:30:48 GMT20http://www.sqlservercentral.com/Forums/Topic1383222-147-1.aspxIf all the flat files have the exact same structure: yes. Use a For Each Loop with a dataflow inside and expressions on the connection managers.If they don't have the same structure: no. It's not possible. You'd need to create seperate dataflows for each flat file.Mon, 12 Nov 2012 00:52:45 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1383222-147-1.aspxCan we load the data from multiple flat files (located in different folders) into multiple excel files (NOT excel sheets) using SSIS? Is there a way to create one excel file for each flat file dynamically? Please help! Thanks in advance.Fri, 09 Nov 2012 13:35:56 GMTchaseurpuli