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.
1. Drag and Drop Dataflow Task to Control Flow
2. Create a Object Variable
3. 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.