how to get parameter value in Execute sql task

Question

Hi experts,

I have set the parameter in execute sql task, is it possible to show the value when i run the package.

I know that i can load the data to table but i want to check the value in VS.

Thank you in advance.

Answer 1

Hi @kulomiabc,

Please follow below steps.

Write the results of your SQL query out to a variable, try single row first, if you have a full result set then it gets a little trickier.

1 . Create a string variable eg: @resultsfromquery.

2. In you SQL Task container, choose ResultSet Single row
3. Choose Result Set from the menu on the side GENERAL, ParameterMapping, Result Set, Expressions.
4. Set the Result Name to 0 and the VariableName to your variable eg: User::resultsfromquery
5. Add a breakpoint to your SQLTask, you can use Break when the container receives the OnPostExecute
6. Start Debug (F5)
7. When debug starts you will have the extra option of adding a WATCH window.
8. When the watch window appears drag your variable onto the watch window.

When your package hits the breakpoint, you will then see your results appear in your variable.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.