Jul 11, 2016

What is Configuration Manager in SSIS

Definition: SSIS configuration is the way to make package dynamic.

Problem: Suppose we developed the package in local or developer machine, when we done with our package we have to move this package in different environment for the deployment like SIT, QA, Staging, UTA, Production etc. We need to specify different parameter values for things like database connection strings, file and folder paths, etc. To resolve this problem Microsoft provide us configuration manager.

Configuration available in SSIS 2012, SSIS 2014, SSIS 2016
  1. XML configuration files
  2. Environment variables
  3. Registry entries
  4. Parent package variables
  5. SQL Server configurations

In SSIS 2008 available configuration
  1. XML configuration files
  2. Environment variables
  3. Parent package variables