SSIS - Execute SQL Task - Result Set and Parameter Mapping

In this post,let us see an example for capturing query result (single valued)  into SSIS variable and insert the captured data in the variable into another table.

First create a variable in the scope of package with Data Type as INT32.

Drag & drop two Execute SQL Task on the Control Flow tab.

Follow as shown in below screen shots :

1 comment:

Mukesh Singh said...

Use Variable in Execute SQL Task
We can use one or more variables in Execute SQL Task to pull the information from the database. To pull the values from database, we can use the SQL Statement or stored procedure with the parameters. To know more
Use Variable in Execute SQL Task