the code that I'm using is as per various threads that i've found on the net, but i get an 'unknown argument on command line' error as follows...
unknown argument 'rootopen.txt+myfile.xml+rootcls.txt' on command line.
the code i am using is...
Expand|Select|Wrap|Line Numbers
- bcp "SELECT * FROM DBNAME..TABLENAME FOR XML RAW" queryout myfile.xml -SSERVERNAME -T -c -r -t copy/b rootopen.txt+myfile.xml+rootcls.txt myfile.xml
any ideas?