Result Set Xml Ssis. On the Result Set tab click Add and select the varSalesSummaryXML variable from the list. Another consideration for choosing the FOR XML statement is that the SELECT statement can be called from a stored procedure DTSSSIS package or a script.
The query returns a result set in an XML format. SSIS XML Destination sample Our first solution is a custom SSIS component created by the Microsoft SSIS team. The option you select depends on the results of the query you pass into the Execute SQL task.
As we said before the select statement will return a complete table.
Delete the existing data. We set the Result Set to Single Row on the general page. Next go to the Result Set tab and click the Add button to assign the variables for the return set. Lets continue to build the package.