Hi guys, in SQL Execute Task we have the possibility to store the data in a XML file. Which is the scope to do this? Once that we got the XML file what can we do with that?
Many Thanks
Technology Tips and News
Hi guys, in SQL Execute Task we have the possibility to store the data in a XML file. Which is the scope to do this? Once that we got the XML file what can we do with that?
Many Thanks
Hi,
Check this post
http://www.rad.pasfu.com/index.php?/archives/25-SSIS-Sql-Server-to-XML-Save-to-file.html
Hi DIEGOCTN,
The XML result set in Execute SQL Task is used when the query returns a result set in an XML format. Then we can save the result in a XML file as specified or use XML source consume the XML data when the variable has the String data type.
If you need the result of the query in Execute SQL Task in an XML format, then you can set the result set as XML. If you dont need this, you can select other result set for your other requirements. It means that this option is used to prepare for the people that need the result of the query in Execute SQL Task in an XML format, then they can make use of the XML file or XML data.
Thanks,
Katherine Xiong