I'm trying to run a package from SQL agent and set variables using the using the Set Values tab and then specify the package path and value.
I've check the path and values are correct and no errors are generate.
However, when run the package write files to the default defined location - so it's ignoring the set values?? Is this because itself calls package configuration values??
I guess in short my question in what order of precidence does SQL agent / SSIS pick up and configure variables?
MCITP: Business Intelligence Developer (2005)