I am currently trying to export some data from MS SQL 2014 to a XML document. I've gotten help from here earlier on this project and I am very thankful for that.
At the moment the data is structured correct and is as it should be, but, unfortunately the server (Totalview server) that is picking up the XML document is very picky about the XML document. The MS SQL server is making a stamp on top of the document which is saying following:
XML_F52E2B61-18A1-11d1-B105-00805F49916B
because of this stamp is written in the XML document the Totalview server cannot load the file. I have looked on google alot and Microsoft's helppages but cant find anything on this, maybe im using the wrong words or looking wrong places, which is why i am asking in here with you great guys. What i want is for this stamp to be replaced by this stamp:
< ?xml version="1.0"?>
it doesnt matter how its done and i have thought of making some kind of script that will change this after the SQL server outputs the data file but it would be nice to get the SQL server to output it correctly in the first place so there is fewer steps that could fail, but is it the only way ?
Kind regards and thanks in advance, i am very sorry for any mistakes made in this question, i am still quite new to this site.
No comments:
Post a Comment