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
3. Now, drag a Execute SQL Task to Control Flow. Rename it. And go to Edit. Configure SQL Statement Section
4. Now, since we want to store a value to the variable, change the Result Set property to Single Row
5. One last step, go to result set section and map Result Name (remember the column name from #1?!) with Variable Name:
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.
2 thoughts on “SSIS – How to use Execute SQL Task to assign value to a variable?”
ModifiedDate is String or Date ? You created the varible data type String.