Post reply

Multiple Excel files into a single table

  • October 27, 2008 at 7:48 pm

    #124113

    I have several Excel files (7 to be exact) which represent slices of a composite Excel file so when I put all of them side-by-side, the original Excel is fully reconstructed. This means that except for the first column in each file which stores the key, the structure of each file is different.

    How can I use SSIS to loop through these files and load each into its own table?

    After the loop, I will probably execute a SQL Task to put all the slices back into a composite table.

    Thank you.

  • October 27, 2008 at 8:59 pm

    #890381

    The "ForEach Loop" container is what you need to loop through the list of files. When you use this, the container gives you a variable which is the name of the file which you can use as an expression to set the file name for the Excel source for a dataflow. Have a look at topic "Foreach Loop Editor" in Books Online.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply