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.
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.