Configuring Packages
One of the greatest features of SSIS is its support for package configuration, which allows properties of objects in the package to be changed without opening the package. For example, you might want to have the ability to enable or disable checkpoints in your package. Note that although you could include properties of connection managers in your configuration, SSMS provides direct support for editing them because it is such a common task.
You'll set up a package configuration in Exercise 6.4.
EXERCISE 6.4: Creating a Package Configuration
In this exercise, you'll create a package configuration.
- Choose SSIS
Package Configurations. ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide 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.
