Insert into text file without overwriting

[AngelB]

Hi All

I am using a DTS package in SQL Server 2000 to transfer daily data to a text file for upload into a different system. What I would like to do is insert records into this text file rather than overwriting the file every time the package runs. Is there a way to do this or will I have to generate a new text file every time? I would like to avoid this if possible.

Thanks


Geraint

The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy