Post reply

SQL Agent / SSIS Package - Set Values

  • March 12, 2013 at 11:01 am

    #269775

    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

    #1597490

    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

  • March 15, 2013 at 10:22 am

    #1597572

    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