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
![](http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/350x0/__key/communityserver-wikis-components-files/00-00-00-00-05/5751.ScreenShot138.jpg)
2. Create a Object Variable
![](http://social.technet.microsoft.com/wiki/cfs-filesystemfile.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/0842.ScreenShot137.jpg)
3. Drag and drop a Datasource
![](http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/350x0/__key/communityserver-wikis-components-files/00-00-00-00-05/2474.ScreenShot139.jpg)
4.Drag and drop a RecordSet Destination and Map object variable
![](http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x0/__key/communityserver-wikis-components-files/00-00-00-00-05/6661.ScreenShot140.jpg)
Now you are done with getting values to object variable.