How to store data inside a variable in SSIS.

Problem: How to store data inside a variable in SSIS.

Solution:   Recordset Destination

The Recordset destination creates and populates an in-memory ADO recordset. The shape of the recordset is defined by the input to the Recordset destination at design time.

Example:

In the example, I would like to show we can store data using an object type of variable inside of data flow and it creates the table during run time.

Step 0: Create a package and in the control flow add Data flow task and create a variable with object type.

Step 1: Edit the data flow task and select an ole db source and with the connection managers connect to a db and select a table.

Step 2: for the destination piece use a record set destination and from the drop down select the variable created in step 0 for read write and in the input output columns select the columns you chose to send as input.

Step 3: execute the package.

Output:

In the next article let’s see how we can use this variable as a source to call outside of this data flow.