Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
psystems
Starting Member
8 Posts |
 Posted - 2005-10-06 : 10:10:32
|
| I have a dts package which will output a pipe delimited text file. I need to add a header & trailer line to the output file. Is this possible and if so how? If not possible what might be some options?Thank you, |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2005-10-06 : 10:13:28
|
If the pipe delimmited file is being generated from a sql query then you can inlude 2 unions in the select one for the header and one for the trailer and ensure some kind of logic to order the query in such a way that the header is returned first and the footer last.Duane.  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
DTS output text file, can you add lines