How Can I set container variable (scope) of SSIS package

Question

How Can I set container variable (scope) of SSIS package

Jerry_2424 0

User's image

Scope of this variable is Event Handler.

I am doing I want it will run by powershell but its not working dtexec /FILE $packagePath "/SET \Package.EventHandlers[OnPreExecute].Variables[User::Variable111111111].Properties[Value];`"1`" " Error :-
Code: 0x80012017 Source: Demo Description: The package path referenced an object that cannot be found: "\Package.EventHandlers[OnPreExecute].Variables[User::Variable111111111].Properties[Value]". This occu rs when an attempt is made to resolve a package path to an object that cannot be found. End Warning DTExec: Could not set \Package.EventHandlers[OnPreExecute].Variables[User::Variable111111111].Properties[Value] value to 12222222.

Greg Low 1,985 Reputation points Microsoft Regional Director

2024-02-22T23:31:52.73+00:00

In most recent versions of SSIS, when you create a variable, it takes the object that you have currently selected (i.e., clicked on) to determine the scope. This sounds like something you're going to want at the package scope instead.
Jerry_2424 0 Reputation points

2024-02-23T05:58:03.1+00:00

@Greg Low Yes you are right but I am facing the issue to do that particular part so what can I call that particular variable?
Greg Low 1,985 Reputation points Microsoft Regional Director

2024-02-24T07:10:33.6433333+00:00

Referencing a package variable just shouldn't have the rest of the path i.e., something like:
"\Package.Variables[User::Variable11111111].Properties[Value]". But you'd also have to have already created it as a package scoped variable in the package.

Your answer

Greg Low 1,985 Reputation points Microsoft Regional Director

2024-02-22T23:31:52.73+00:00

In most recent versions of SSIS, when you create a variable, it takes the object that you have currently selected (i.e., clicked on) to determine the scope. This sounds like something you're going to want at the package scope instead.
Jerry_2424 0 Reputation points

2024-02-23T05:58:03.1+00:00

@Greg Low Yes you are right but I am facing the issue to do that particular part so what can I call that particular variable?
Greg Low 1,985 Reputation points Microsoft Regional Director

2024-02-24T07:10:33.6433333+00:00

Referencing a package variable just shouldn't have the rest of the path i.e., something like:
"\Package.Variables[User::Variable11111111].Properties[Value]". But you'd also have to have already created it as a package scoped variable in the package.

Share via

How Can I set container variable (scope) of SSIS package

Your answer