I wonder if anyone can advise.
I need to create an XML file to test importing data into an SSIS package from XML, I can't change the format of this so changing the format is not an option. I'm creating the XML File fine with small numbers of rows, but when I try to do a large number of rows I'm getting the message below when I click on the results to view in XML format.
I've tried doing what it recommends and increased the size in the Query Results options to Unlimited under XML Data: but that has not resolved the issue.
asked Apr 17, 2012 at 10:56 AM in Default
A workaround for this is to change the script that produces the XML to a stored procedure. Then create a text file that looks like:
Where XMLTest is the name of the stored procedure.
Then open a command prompt and enter:
And this creates a very large XML file.
answered Apr 17, 2012 at 01:13 PM
I would rather try to save the results by right clicking the xml result link -> Save Results as -> Select All files -> Name the file as Name.xml. This way the proper format would be retained. Moreover, I think the "query options" would not do the job, as it is some kind of SSMS is not able to handle huge XML in memory, so giving out of memory exception.