XML Export to Flatfile

[Atavistic]

I am working in SQL 7.0 writing a querry to an XML result set. The first hurdle I discovered was that the length of a column can be a maximum of 7000 chars. I am now calling the SELECT to XML multiple times because of the 7000 limit. I decided to store each result set to a flatfile that I can pick up after the querries have finished. bcp and dts are not working right now top write to a flatfile because they overwrite the previous result set each time. I need to be able to append each result set as I querry. I can handle deleting the file later once I have picked it up.

Any ideas or alternative solutions to my problem? [sig][/sig]

 

[ColinM]

What about shoving it into a text column? [sig][/sig]

 

[Atavistic]

I tried that but you cannot INSERT INTO when you are generating XML. Thanks for the idea. [sig][/sig]