|
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. Any ideas? Many thanks
(comments are locked)
|
|
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.
(comments are locked)
|
|
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. How do you save it as XML from there?
Apr 17 '12 at 12:45 PM
Mrs_Fatherjack
As I said earlier that you have to select the option "All files" from file type while saving the GRID results. Somehow the upload image option is telling me the file type is invalid. So not able to show it graphically :(
Apr 17 '12 at 01:24 PM
Sacred Jewel
(comments are locked)
|
can you include any code you are using to build the XML? How many rows are involved when it errors? Have you tried changing the output to Text (Ctrl + T) rather than Grid ( should be Ctrl + D but currently isnt working for me) or File
The code works fine for smaller samples, when the file gets beyond approx. 13.5 mg it starts erroring. Will try saving it as file or text.
I do not think output to TEXT will work as it has more limitations for xml than in GRID mode.