Click here to Skip to main content
15,867,282 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/[^]
 
Share this answer
 

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