March 12, 2013 at 11:01 am
Hi all,
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)
March 15, 2013 at 7:37 am
Read the part Understanding How Package Configurations Are Applied at Run Time
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2013 at 10:22 am
Thanks Koen.
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy