Result Set Variable Ssis. In Result Set write 0 as Result Name. In Variable Name select the variable foldername.
Image 10 For 11 Important Database Designing Rules Which I Follow Database Design Database Structure Database from in.pinterest.com
If the result set type is Full result set or XML you must use 0 as the result set name. 3-Create a connection to MSDB and use SELECT FROM systables as an SQL Query and Set Resultset to Full Result Set. I need to do this becuase the results from a query is on a different NON.
Full result set could be stored in Object typed variable to use within other places in SSIS.
Figure 6 Result Set Tab. In Variable Name select the variable foldername. Parameter Mapping is used to pass parameter into the t-sql query and to return value from the t-sql query. Hi SSIS - I put a resultSet in a variable.
