How to reference values between tasks in SSIS

Question

Hello,

The "Execute Process Task" calls the VBS, and the VBS returns a value.
I want to use this return value in a subsequent "Execute SQL Task" (e.g. 'exec [dbo]. [spr_hoge] @Arg_095 = [Want to set a value here]').

I think I will use ExecValueVariable, but I don't know what to do after that.
How can I achieve this?

Thanks in advance.

Answer 1

Hi @dsk ,

In the Execute Process Task, create a new StandardOutputVariable named as output.

And then use Execute SQL Task, enter the code.

exec [dbo]. [spr_hoge] @arg =?  

Go to the parameter mapping, add the output::variable.

Check this link about ssis-use-variable-in-execute-sql-task.html.

http://kenssqlserverblog.blogspot.com/2008/10/output-results-using-execute-process.html

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.