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

No comments:

Post a Comment

Please do not enter any spam link in the comment box.

NUnit : Introduction

There are several unit test tools in the market, but one of them is NUnit, the most popular tool for doing unit testing. So in this tutorial...