O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the Dynamic Package Configuration Wizard

An important, and practical, consideration when implementing SSIS packages is creating packages that can easily be moved from a development environment to a production environment. As stated in the “General ETL Package-Design Best Practices” section of this chapter, this means that many package values, such as connection string, should never be hard-coded into a package. The Package Configuration Wizard will help you accomplish this goal.

To access this wizard, you choose SSIS Image Package Configurations from the BIDS menu bar. Once in the wizard, you can set most properties of an SSIS package via a number ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required