January 9, 2006 at 4:09 pm
Is there a way to have DTS export text append the file instead of overwritting? Any other suggestions?
January 11, 2006 at 4:34 am
There does not seem to be an append option, so my approach would be to have the DTS task create a temporary file and then use a batch file triggered by DTS to append the contents of this temporary file into the target file.
January 11, 2006 at 12:05 pm
Open a connection to the file with the delimited text driver and insert the new records? I'm guessing here - haven't tried it but it makes sense to me.
Artificial Intelligence stands no chance against Natural Stupidity.
January 11, 2006 at 3:15 pm
Stage all of the data into a holding area, then export to one text file? Export to several temp files, then use a Command task or even VBScript if you're adventurous to concatenate the files together (e.g. type temp*.tmp > MyDesiredOutputFile.txt)?
I don't know about the text driver as I've never experimented with it. Seems like your best bet is just to gen the files and concatenate, then delete the temp output. Not a great solution, but it does work.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply