question

techboys avatar image
techboys asked

Import multiple excel worksheets from one file into 1 SQL table

I am trying to build a SSIS package that will take one Excel file with mulitple worksheets and load it into one SQl table. The Excel file will usually have 3 worksheets with the exact same structures and column names.. and the names will always be the defaults..ie Sheet1, Sheet2 . The Excel file name will always be the same also. I am not very familiar with SSIS and have started with using the wizards but can't seem to find a solution to import 3 worksheets into 1 SQL table. I would really appreciate any help. Thanks
ssisexcel
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Usman Butt avatar image
Usman Butt answered
Since this include quite a few steps, following are good Technet links to help you out. http://technet.microsoft.com/en-us/library/ms403358.aspx http://technet.microsoft.com/en-us/library/ms345182.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.