How to Keep Variable in Scope

Question

I'm setting a variable value in script task then passing the variable to an Execute SQL task. The variable isn't keeping its value. There's not an error.

Answer 1

Hi @Shiela E 2021 ,

As shown in your screenshot, you are using oledb source.

You should map variable @[User::Status] to parameter named 0 and the parameter size you could set to default -1.

Helpful links: https://learn.microsoft.com/en-us/sql/integration-services/control-flow/execute-sql-task?view=sql-server-ver15

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d63df15e-e032-4c77-b329-b118c5986e23/passing-variable-from-script-task-to-execute-sql-task?forum=sqlintegrationservices

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.