SSIS – Merge Transformation
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 :