Pages

Men

rh

4/26/2012

What are all the Configuration files are available in SSIS

Five types of Configuration Files are available.
  • XML Configuration File
  • Environment Variable
  • Registry Entry
  • Parent Package Variable
  • SQL Server
XML Configuration File:
It stores the configuration settings in XML File in the File System. We can store multiple Configuration information in one single XML File.

Environment Variable:
Saves the configuration information in inside the System's Global variable collection called Environment Variable. When we add Environment variable you can choose only one property for each environment variable configuration.

Registry Entry:
It stores the package properties and settings inside the Computer Registry.

Parent Package Variable:
It provides a way to inherit the value of variable from Parent Package. When the package is executed by using executing Package task, the values of variable are available to the child package through the parent package variable configuration.

SQL Server:
Uses SQL server table to store package settings information. It allows to store multiple configuration in a single file.

In which scenario  you will use SQL Server to store the configuration settings?
If you have multiple packages that need to  share a configuration but packages are executing on different computers, you should use the SQL Configuration Type.

In which scenario you will use Parent Package Variable  to stores settings of Configuration  information?
If you are executing Package together, with one package is executing a second package by using Execute Package Task and you need to pass the value of variable from parent package to child package, you should use the parent package variable configuration.

In which scenario you will use Environment Variable  to stores settings of Configuration  information?
If you are planning to move from a development server to text server and then to production server and each environment  needs to be different location for configuration you should use "Indirect Configuration Set up for the configuration". This uses Environment variable on the system.

In which scenario you will use XML Configuration File  to stores settings of Configuration  information?
If you have more than one Configuration entry that you want to put in a single SSIS Configuration, you need to use
XML Configuration File.

No comments :

Post a Comment