Theoric question...XML file and SQL Execute Task

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

September 8th, 2015 9:29am

Thanks. It's just the meaning to save the results in a XML file that I do not understand. Why?
September 8th, 2015 9:59am

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

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 2:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics