January 15, 2014 at 12:21 pm
In the package configurations window, I see that I can select the order in which the configurations will be loaded when the package runs. What is the need for to have an order option in SSIS, ie use cases ?
January 15, 2014 at 1:09 pm
The configurations are applied top to bottom.
This is useful if you have an indirect configuration:
You have stored all your configurations in a SQL Server table (or an XML file if you must), but if you move the package to another server you want that SSIS can still find that table. So you put a configuration on the connection manager pointing to your configuration database. This configuration is usually an environment variable. All you need to do is to make sure the environment variable exists on all environments with the same name. If you move a package between environments, it will pick up the correct configuration database.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply