Result Set Sql Task Ssis. Write the results of your SQL query out to a variable try single row first if you have a full result set then it gets a little more tricky. 3-Create a connection to MSDB and use SELECT FROM systables as an SQL Query and Set Resultset to Full Result Set.
Msbi Ssis Etl Dwh Online Classroom Trainings At Sql School Attend Free Demo On Nov 6th At 12 15 Classroom Training Online Classroom Online Training from in.pinterest.com
Remember if you specified the Result set property as None then this tab is disabled. The Proc inside Execute Sql Task returns Start and End date I stored those values as full result set on an object variable. SSIS - Execute SQL Task - Result Set and Parameter Mapping In this postlet us see an example for capturing query result single valued into SSIS variable and insert the captured data in the variable into another table.
Create a string variable eg.
To do so Drag and drop the Execute SQL Task from SSIS toolbox to designer space. When using an Execute SQL Task in SSIS result sets can be generated from an SQL command mostly a SELECT query. Now I need to pass that result set start and end date to a data flow task. Please refer to Looping Through a Result Set with the ForEach Loop.
