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
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
3 People are following this question.
