Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
There are several methods to store the your data into Object Variable in SSIS. (See: SSIS - Mapping Full Resultset with Execute SQL Task to Object Variable)
The second method is by Dataflow Task and a Recordset Destination.
- Drag and Drop Dataflow Task to Control Flow
Create a Object Variable
Drag and drop a Datasource
4.Drag and drop a RecordSet Destination and Map object variable
Now you are done with getting values to object variable.