Click here to Skip to main content
14,981,762 members
Please Sign up or sign in to vote.
1.20/5 (2 votes)
See more:
New to SSIS, how do I load 5 excel workbooks with 5 different worksheets (few columns from each worksheet (not same in each worksheet) will comprise the data) with data starting on different rows and columns? Data needs to go to a table which will get new data on an annual basis. Is there any example available?

Thanks in Advance
Posted

1 solution

we have simple way to load excel into database tables with DTS packages. How to do that check in below link.

http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900