Moving SSIS packages from DEV to Prod

  • 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

  • Use an environment variable.

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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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