SSIS Interview Questions Answers | How would you load data into Object Type variable in SSIS Package

In this video you will learn the answer of SSIS Interview questions "If you have created object type variable that you want to use in script task later, how will you load data into Object Type variable in Control flow? Which task will help? "

In this video you will learn
How to create Object type variable in SSIS Package
How to use Execute SQL Task to load data into Object Type variable in SSIS Package
How to configure Execute SQL Task with Full Result Set to save recordset into object type variable.
How to use RecordSet Destination in SSIS Package to save data into object type variable
How to save data in Object Type variable in Data Flow Task in SSIS Package

Complete List of SSIS Interview Questions by Tech Brothers