November 8, 2011 at 4:27 pm
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/
November 8, 2011 at 11:59 pm
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
November 9, 2011 at 6:04 am
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/
November 9, 2011 at 6:29 am
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
November 9, 2011 at 7:36 am
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/
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy