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!

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

adding multi line header in text file

Status
Not open for further replies.

claws2rip

Programmer
Dec 14, 2001
80
US
Does anyone know whow to add two lines in a header for an export to a text file?

Basically i transferring data from sql table to a text file but i need two header lines in my text file

example :

Version-5.1
spr-comma delimitted
7647, john smith, 123 main st, newport, ri
3459, jane collins, 123 main st, new york, ny
1266, robert johnson, 123 main st, boston, ma

in the text connection manager i tried adding two lines but it put them both on one line.
 
Have you tried using the Script Task (control flow) or Script Component (data flow)? One of those might work.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top