I’m happy to announce the latest version of our SSIS Framework includes global parameters! I can hear some of you thinking, …
“What Are Global Parameters, Andy?”
I’m so glad you asked! SSIS ships with package-scoped and project-scoped parameters. Project-scoped parameters may be used in any SSIS package in the project; package-scoped parameters are only available within the context of a single SSIS package. This functionality reduces repetition in SSIS package development and execution configuration.
Global parameters allow our SSIS Framework customers to set parameters and values that apply to the entire SSIS Catalog.
Now that you know what they are, Andy has an example of them in action. Global parameters aren’t part of the community edition, but they do look interesting.