Ssis Sql Task Result Set Xml. Am forced to use this approach and cannot use the standard control flow task of SSIS. Disable Contain 3 and enable Container 4 in the package.
Execute Sql Task In Ssis from www.tutorialgateway.org
Now Double click on the Get Count Execute SQL Task and click on the Result Set and click Add. Please change the SSIS Execute SQL Task ResultSet property value from NONE default to the Full result set. In this section well demonstrate how to set an object variable to hold the SQL result in XML format and how to set parameters in SQL statements.
5 Mar 2013 2 min read.
If the result set type is Full result set or XML you must use 0 as the result set name. To do this go to the Result Set page of the Execute SQL Task Editor. The SQL use in the task is. Replace the earlier code to get xml in Data variable with the new code as below.
