I am exporting XML query results from a stored procedure using bcp. The query is pulling data from several tables and create XML using FOR XML EXPLICIT.
The following is the bcp command used to export the result:
bcp "exec sprocname" queryout output.xml -w -T
The resulting output file appears to limit the number of charcters per line to 2033 characters and cut the data into the next row regardless whether the 2033th character is in the middle of an xml tag. As a result the resulting xml output become unreadable.
Any suggestions would be much appreciated.
I hope you are using SQL2005. If so, just add ,TYPE at the end of your FOR XML query as
SELECT ...
FOR EXPLICIT, TYPE
No comments:
Post a Comment