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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.