SSIS - Storing Dataflow Results to Object Variable with Recordset Destination

  • Article

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

  1. Create a Object Variable

  2. 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.