I need to pass a value to a package level variable in an SSIS package from a
SQL Agent job. If I use dtexecui the syntax for passing the variable in the
Property Path is

\Package.Variables[User::MyVar].Properties[Value]

and the package runs fine.

When I use this syntax, or any similar format I can think of, in SQL Agent,
my job fails. In SQL Agent you put this in the Property Path on the Set
Values tab of the Step that runs the package. If I remove passing in the
variable my package runs fine.

BOL says use the format Package\<container name>.<property name> but I can
find no examples. Can anyone provide a working sample to make this work?

Thanks.