Question- What is 'Package Configuration' is SSIS?
Answer- Usually at the time of project development, we follow different types of environments in different servers to roll out the solution to the final stage.
If it is required to move SSIS package from one server to another server Due to any deployment activity, then It will also be required to reset the connection information and other file paths, folder locations etc. We can perform this activity by two ways either -
Directly Change into the packages(More work, Not a good practice)
or
Change only at the configuration level and it will affect the entire package (Best practice)
Definition - Package configuration is a feature given by 'Microsoft' in SSIS solution which holds the configuration values such as connection string, file paths, folder locations etc., and avoid any direct change into the package at configuration/package level.
Question- Why we use 'Package Configuration' feature in SSIS?
Answer- We use 'Package Configuration' feature to avoid any direct change on SSIS package at configuration level.
Question- What are the different configuration types available in SSIS package?
Answer - There are five ways in SSIS package to achieve the package configuration.
Answer- Usually at the time of project development, we follow different types of environments in different servers to roll out the solution to the final stage.
If it is required to move SSIS package from one server to another server Due to any deployment activity, then It will also be required to reset the connection information and other file paths, folder locations etc. We can perform this activity by two ways either -
Directly Change into the packages(More work, Not a good practice)
or
Change only at the configuration level and it will affect the entire package (Best practice)
Definition - Package configuration is a feature given by 'Microsoft' in SSIS solution which holds the configuration values such as connection string, file paths, folder locations etc., and avoid any direct change into the package at configuration/package level.
Question- Why we use 'Package Configuration' feature in SSIS?
Answer- We use 'Package Configuration' feature to avoid any direct change on SSIS package at configuration level.
Question- What are the different configuration types available in SSIS package?
Answer - There are five ways in SSIS package to achieve the package configuration.
- Environment variable
- XML configuration file
- SQL server table
- Parent package variable
- Registry entry
I hope this article will make sense to the readers, Please mark your comments.
You make take more interest about brief explanation on following topics -
0 Comments