December 22, 2008 at 10:41 am
A user wants me to send them a formatted XML file.
The "for xml, auto,elements" seems to create the data I need.
However when using it in Query Analyzer, it is very difficult to extract large files due to truncation errors.
How can I extract the data in a manner that eliminates this problem?
Any advice would be appreciated.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
December 22, 2008 at 11:30 am
I've used BCP to do just that in the past. I forget the actual command line switches, but go with ASCII, no delimiters, and dump it right into a file.
Even though it sometimes whines about the possible truncation, it hasn't done it to me.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply