Here are seven things everyone should understand about package configurations:
- Using one configuration file (resident configuration) per server is optimal.
- You can apply more than one configuration to a package.
- You can apply one configuration to more than one package (this is how resident configurations work).
- Each package configuration is applied in the order shown in the Package Configurations Organizer—except Parent Package Configurations, which are applied at execution time.
- If an entry in a configuration fails, it will only emit a warning. Configurations should never raise an error or cause a package load to fail.
- You can explicitly set a configuration's location in the package or you can point to it from an environment variable.
- Configurations are applied at load time, not execution time. So changing a configuration in the designer and then executing the package without reloading it won't apply the configuration. You must reload the package.