Package Configurations
The next step in the deployment journey after having created a package is to create package configurations. By now, you should understand the versatility of variables and their preferable use in packages over hard-coding the values. Also in Integration Services, you can update the variable values using other components at run-time to add some dynamics to your package. This concept has been extended to properties of SSIS control flow components by package configurations. As mentioned, package configurations allow properties of a package, its control flow container, or any of the tasks, variables, or connection managers to be changed at run-time. Package configurations are in fact property/value pairs that you use to update ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access