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 ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.