Home Forums Data Warehousing Integration Services Automaticaly Build and Deploy SSIS packages. RE: Automaticaly Build and Deploy SSIS packages.

  • December 16, 2018 at 12:48 pm

    #2016416

    Phil Parkin - Sunday, December 16, 2018 12:15 PM

    Jeff Moden - Sunday, December 16, 2018 10:17 AM

    @Phil...
    As you know, I'm far from even being a casual user of SSIS never mind an authority of any kind on the subject but...Isn't the OP going to have to do a one time modification of each of his "100's of packages" to take advantage of the variable/mapping that you speak of?

    If all that we are talking about is setting run-time overrides of the values of certain existing parameters and connection strings within SSIS packages and projects, no code changes will be required to the packages.

    But ... there is a lot of one-off config work to do to create the mappings from SSISDB environment variables to those parameters and connection strings. With care, this can all be scripted, but the scripting support is not as good as it might be.

    Thanks, Phil.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)