• Quote from this MSDN page: Package Configurations.

    1. The dtexec utility loads the package.

    2. The utility applies the configurations that were specified in the package at design time and in the order that is specified in the package. (The one exception to this is the Parent Package Variables configurations. The utility applies these configurations only once and later in the process.)

    3. The utility then applies any options that you specified on the command line.

    4. The utility then reloads the configurations that were specified in the package at design time and in the order specified in the package. (Again, the exception to this rule is the Parent Package Variables configurations). The utility uses any command-line options that were specified to reload the configurations. Therefore, different values might be reloaded from a different location.

    5. The utility applies the Parent Package Variable configurations.

    6. The utility runs the package.

    Are you being bitten by number 4?

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