Five types of Configuration Files are available.
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?
In which scenario you will use Parent Package Variable to stores settings of Configuration information?
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.
- XML Configuration File
- Environment Variable
- Registry Entry
- Parent Package Variable
- SQL Server
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 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