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
- XML configuration files
- Environment variables
- Registry entries
- Parent package variables
- SQL Server configurations
In SSIS
2008 available configuration
- XML configuration files
- Environment variables
- Parent package variables
No comments:
Post a Comment
Please do not enter any spam link in the comment box.