Result Set In Sql Task Ssis. The Execute SQL task is one of the handier components in SQL Server Integration Services SSIS because it lets you run Transact-SQL statements from within your control flow. You can refer to the Microsoft official documentation to learn more about Execute SQL Task in SSIS parameters and return values.
Please click on the Add button to add the result set name. SQL Server all supported versions SSIS Integration Runtime in Azure Data Factory The Script task uses the TaskResult and the optional ExecutionValue properties to return status information to the Integration Services runtime that can be used to determine the path of the workflow after the Script task has finished. Remember if you specified the Result set property as None then this tab is disabled.
You can refer to the Microsoft official documentation to learn more about Execute SQL Task in SSIS parameters and return values.
Please click on the Add button to add the result set name. 1In the General page of Execute SQL Task we can set ResultSet as Full result set. On the Result tab map the Result Name 0 to the variable you created above. What the result set contains also varies by SQL command.