Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS to CSV--eliminating the column header

Status
Not open for further replies.
PTW

PTW

Programmer
Jul 7, 2000
82
CA
Hi Everyone,

Simple question: when exporting data from a SQL Server 2000 database into a CSV file, I want to avoid exporting the column names (Row 1). Under "Transform Data Task Properties" and "Options" I set the "First Row" to a higher number, but it still keeps exporting that header row.

Is there any way I can have that automatically stripped out? Thank-you.

PTW
 
Sort by date Sort by votes
On the Destination Connection to the CSV check the properties of the CSV and make sure "First Row contains Headers" is unchecked
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
154
botatun
botatun
Fsoumia
  • Locked
  • Question
DTS Logging
Replies
2
Views
167
Fsoumia
Fsoumia
Azzuri
  • Locked
  • Question
DTS To SQL Server 2008
Replies
1
Views
105
mrdenny
mrdenny
mutley1
  • Locked
  • Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
74
mutley1
mutley1
Imakeoil
  • Locked
  • Question
Used DTS Migration Wizard but can't find the DTS Packs
Replies
1
Views
88
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top