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...
This comment has been removed by a blog administrator.