SSIS has a LOT of ways to set configs. Parameters & variables, and then those can be overridden at different levels.
in order (from lowest to highest) - bottom of this list supercedes the top. You can see WHERE it was overridden because at that level, the parameter name is in bold.
- SSIS Package level
- SSIS Project level
- XML Configs? (I don't remember where these can be set)
- SSISDB - right-click on the project within integration catalog and choose "Config"
- SSIS Job Step configuration
No comments:
Post a Comment