Andy Brownsword continues a series on SSIS:
Yep it’s more SSIS again this week. Here we’ll be looking at using Environment configuration within the SSIS catalog. This allows sets of parameters to be defined and used across multiple projects and packages which share common values.
This approach can either be used as a central point for configuration, or you could use multiple configurations for the same packages.
Read on for some examples of how you might use them, as well as the process to create one.