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 :
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:
Post a Comment