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 
Package Configurations from the BIDS menu bar. Once in the wizard, you can set most properties of an SSIS package via a number ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.
