First Row Contains Column Headers - Export to Excel OLEDB Destination Task

Question

First Row Contains Column Headers - Export to Excel OLEDB Destination Task

Welsh Corgi

SSC Guru

Points: 116520
More actions
November 8, 2011 at 4:27 pm

#259652

I want to turn off First Row Contains Column Headers when Exporting to an Excel OLEDB Destination Task.
Not that it matters but I have a Data Conversion Task between the OLEDB Data Source and OLEDB Data Destination (Excel 12.0 set in Advanced Properties).
I would greatly appreciate any help.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 1

Click on the Excel connection manager. In the properties, locate the connectionstring property. There, change HDR=YES to HDR=NO.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Koen Verbeeck (11/8/2011)
Click on the Excel connection manager. In the properties, locate the connectionstring property. There, change HDR=YES to HDR=NO.

Koen,

I could not use the Excel Connection Manager.

I'm using Excel 2007 and I can't use Excel 97 because there are a couple of the Sheets that have over 159,000 Rows being populated.

I'm working with an OLEDB Connection Manager.

Thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

Are you using SSIS 2005 or 2008?

I can use the Excel connection manager for Excel 2007 without a problem.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

Koen Verbeeck (11/9/2011)
Are you using SSIS 2005 or 2008?
I can use the Excel connection manager for Excel 2007 without a problem.

Unfortunately I'm using SSIS 2005.

I started out using the connection Manager but I could not save the file as an xls or xlsm.

Thanks!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/