Is it possible to Load Data directly from Multiple Excel Sheets Into Pipe Delimited TXT File using SSIS..?

Question

Can we load the data from a multiple excel sheets into txt file using SSIS without a temp table in between..?

I Tried it by loading the data of the multiple excel sheets into a table. After I loaded the data from the table into a TXT file. Is it possible to do without loading into the table Using SSIS..?

Answer 1

You can start by creating a vatiable :

Add a Foreach Loop Container in the Control Flow Task :

With the following configuration :