Seeing
as your talking about dts i asume your on a windows box, so, could you use the
WIN32 FileSystemObject and just read the first line, append your text, then
write the first line back in using the stream?
--------Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco Fleur
Sent: Monday, January 12, 2004 4:30 PM
To: CFAussie Mailing List
Subject: [cfaussie] Prepend instead of AppendIs there some way to prepend data to a file, instead of append?
Really what I am after is prepending column names to a LARGE text file, without reading the whole file into memory.
I didn't listen to myself (slap slap) and implemented a hack on some elses recommendation. I used BCP instead of DTS to export large amounts of data to a text file.
I already knew, hacks are quicker but do not provide the full functionality of what you need, and it comes back to haunt you ;-)) as in this case.
The text file is to be used for mail merges, and a mail merge does not work particularly well without the column names.... ;-((
Taco Fleur
---
07 3535 5072
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
