How to use Execute SQL Task in SSIS to assign value to a variable?
This is a beginner level post so I’ll show you how you can use Execute SQL Task to assign a value to a variable. Note that variables can also be given full result set. With that said, here are the steps:
1. Create the query against the source system
Example: ((Note the column name, this will be handy later!)
2. Open SSIS Project > Create the variable
That’s it! Related article: How to see value of variable during Run Time?
In this post, you saw how to use Execute SQL Task in SQL server integration services to assign a value to a variable.