Search code examples
sql-serverssis

Is there any way to change the SSIS connection managers while deploying the packages to different environments?

I am new to SSIS. Right now when I deploy a package from dev and then to production environment, I used to open the solution using visual studio and then editting the connection managers. Is there any other way for doing this?

Thanks in advance. :)

Solution

  • The basis method for controlling and allowing to switch connections between DEV and PROD would be to handle it in Integration Services Catalog, under the SSISDB.

    This allows you to create an enviroment called DEV under your DEV server and a environment called PROD on your PROD server. Each difference is that the variables has different connectionstrings, and hereby you never need to edit them into your SSIS project. So basically you can deploy your SSIS project to PROD with dev connectionstrings, but the environment will make sure it always points to your PROD connections.