SQL Agent / SSIS Package - Set Values

  • 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)

  • Read the part Understanding How Package Configurations Are Applied at Run Time

    Package Configurations

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • 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