Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Excel file Header issue

Author  Topic 

learntsql

524 Posts

Posted - 2012-03-06 : 00:36:29
Hi All,

I have written a package to load excel data into sql server table.
In excel file i am getting two header rows and actually i have to ignore 1st row.
Plz tell me how to consider 2nd row as header row.

TIA.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2012-04-19 : 09:40:26
Can you use the option first_row=2?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -