Set parameter in scheduled job step 1

[Skittle]

I have an Integration Services package with a package wide user string variable.

I want to set the variable in a SQL Agent job.
There is a tab for 'Set Values' which hs a field for 'Property Path' and 'Value'.

What is the syntax for te 'Property Path'?

I have tried MyVariableName on its own.
I have tried User::MyVariableName.

Both are ignored.
Am I missing something obvious?

Dazed and confused

 

[cmartin75]

On the books on line the syntax for the property path is the same that the dtexec utility. (in the command line tab, it generates the command line with the property)

The sintax is:

\Package.Variables[User::Variable].value

http://msdn.microsoft.com/en-us/library/ms162810.aspx

In Microsoft forums I see another way:

Package.Variables[User::Variable].Properties[Value]

I read also in Microsoft forums there's a bug and all of this don't work before sp2 of SQL Server 2005

But I've got the SQL Server 2005 SP2 and I proved all the ways and I still can't see it works

 

[Skittle]

Thanks. I undersand.


Dazed and confused