Microsoft SQL Server 2005 Integration Services

Chapter 14. Configuring and Deploying Solutions

IN THIS CHAPTER

• Package Configurations

• The Package Configurations Organizer

• Package Configuration Types

• Deploying Packages

• Configuration and Deployment Approaches

“MOVING BETWEEN DEV, TEST, AND PRODUCTION IS EASIER NOW WITH CONFIGURATIONS.”—ERIK VEERMAN

In the typical package development cycle, you build packages on one machine, the development machine. After you get all the settings right and the package is performing to your requirements, you move it to a test machine. After testing is complete, you move the package to the production machine. Although the stages and names might differ, most environments have similar testing and deployment requirements that seem at odds with the very ...