SSIS Conifiguration

- Configuration make our package more dynamic – useful for deployment-

Package Deployment (Old Version) - 5 Types of Configuration: -

1. XML Configuration (Best way)
2. Environmental Variable
1. This is tricky in deployment – need some manual creation involved
3. Parent – Child configuration
4. Registry configuration
1. Like environmental variable – most people doesn’t use this
5. Sql server configuration
1. SSISConfiguration table will be created in the user database, which contains four column ConfigFile, ConfigValue, PackagedPath, ConfigValueType
2. If we need to reconfigure, truncate data in SSISConfiguration table

=====================================================================

New - Project Deployment : -

• The configuration option not available
• SSISCatalog – db will be created
• Loging also available in SSISCatelog