Joseph Michael Pesch
VP Programming

SSIS Setting Variables in SQL Agent Job Scheduler (Job Properties)

by 30. October 2008 14:39

You can use the "Set Values" tab on the "Job Step" properties page to set SSIS variable values by placing the path to the variable in the "Property Path" column (e.g. Global variable syntax: "\Package.Variables[User::MyGlobalVariable].Properties[Value]" Object variable syntax: "\Package\MyObject.Variables[User::MyObjectVariable].Value") and the corresponding value in the "Value" column (e.g. "This is a static string variable value...").  NOTE: Do not include quotes in the "Property Path" and "Value" data when entering it into the editor.  Here is a screenshot example:



Comments are closed