BCP... append to a file

[elmo29]

i need to write text
output query
write more text to a file from SQL server 7

I am using bcp, is it possible in anyway for bcp to append to a file rather than just overwrite it? or is there any way where I can 'add' 2 files together using xp_cmdshell??

Any help appreciated

Thanks

 

[ColinM]

You could just use:

exec master.dbo.xp_cmdshell
"copy c:\a.txt + c:\b.txt c:\c.txt"

 

[elmo29]

I thought that was a bit messy, isn't there a nicer way without me having to create 3 files and add them together each time?

 

[tlbroadbent]

1- BCP to a.txt
2- xp_cmdshell 'copy /Y b.txt + a.txt b.txt'.

That's only slightly better but the best I can think of for now. Terry

http://members.home.net/tlbroadbent/index.htm