question

toshmsbi avatar image
toshmsbi asked

The variable was not found in the Variables collection

I am trying to run the job on development server ,which executes master package. the master package contains all the ssis execute tasks for the child packages, But the job fails with the following error message The variable "User::DS_Env_Dest" was not found in the Variables collection. The variable might not exist in the correct scope. Attempt to parse the expression "@[User::DS_Env_Dest]" + "initial catalog=xyz;-----;"" failed and returned error code 0XC00470A6. The expression can not be parsed. It might contain invalid elements or it might not be well formed. there may also be an out-of-memory error. the job ran fine few days ago and i haven't made any changes to the package since then. it's master , child package structure with environment variables assigned to the packages i've checked the master package for the User::DS_Env_Dest variable and does exist in the package i even evaluated and works fine. does this mean the error is in master package or any of the child packages?? please let me know how to resolve this error? am i looking past small error here??
sql-server-2008ssisvariable
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You should know where the error is occurring whether in the child package or in the master package? It can be only s case, that a SCOPE of the variable is different.
1 Like 1 ·
any suggestion would be much appreciated thanks
0 Likes 0 ·

1 Answer

· Write an Answer
Mrs_Fatherjack avatar image
Mrs_Fatherjack answered
I would suggest you create a variable in the child package and then when you execute the child you pass the variable from the master to the child by opening the child package, selecting Package Configurations, then Enable Package Configurations, and add the variable from the master package and setting to the variable in the child package.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.