Post reply

Moving SSIS packages from DEV to Prod

  • February 28, 2013 at 10:00 am

    #269142

    Hello ,

    I have a SSIS package that I just developed for the Development Environment.

    I need to move the package to Production, but the DataFlow Tasks in my

    package point to the Database in my Dev environment.

    Can you please tell me how I can make a change so that I can point to the new database in

    the production environment ?

    Thanks,

    SA

  • February 28, 2013 at 10:21 am

    #1592089

    Use an environment variable.

  • February 28, 2013 at 10:59 am

    #1592121

    Use package configurations to control the values of things whose settings vary between environments.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply