CODEWITHSUNDEEP
visual-studiossis
SamIAm
SamIAm

Reputation: 2491

Can SSIS be configured in Development and then transferred over to the Production Database?

I have a project where I have to migrate data from one database to another. We have a copy of the database on our development server and I am planning to use SSIS with Visual Studio to do this. I have set up Connection Managers with data flows and control flows.

How do i configure it such that all i have to do in the future is to change a setting and that will allow me to run the package from my DEV database to my Production one with ease? Will it be as easy as re-configuring the connection managers? If I try to add a new Connection Manager and point it to that, all my mappings seems to dissapear.

Upvotes: 0

Views: 266

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300559

You should utilise SSIS configuration to make portable between environments

There are several options including xml files, command line options etc.

  • Command line options (/SET)
  • XML configuration file
  • Environment variable
  • Registry entry
  • Parent package variable
  • SQL Server

See Package Configurations

Upvotes: 2

Related Questions