Hi all...I have one task to import data from Excel workbook to SQL using SSIS.
Problem:
There are 200 sheets in an Excel Workbook. I have to import all the sheets and put them in one table in SQL 2005.
I am doing is..I have created a package to start loading data from 1st sheet....
In every sheet there are 5 top rows which I do not want to include in SQL table....
Is their any possible way to use ID column and then as package runs it calculates by itself for rows and deletes it....
Problem:
There are 200 sheets in an Excel Workbook. I have to import all the sheets and put them in one table in SQL 2005.
I am doing is..I have created a package to start loading data from 1st sheet....
In every sheet there are 5 top rows which I do not want to include in SQL table....
Is their any possible way to use ID column and then as package runs it calculates by itself for rows and deletes it....
Comment