Hands-On Microsoft SQL Server 2008 Integration Services part 62. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 588 Hands-On Microsoft SQL Server 2008 Integration Services Under these conditions you will be using either a package deployment utility which can deploy multiple-package projects along with package configurations and miscellaneous files or custom-developed scripts that could be simple windows batch files to do the trick. A sample of a simple batch file will be discussed later in the chapter. A package deployment utility is used after you ve created a package and package configurations and are ready to deploy. To create a deployment utility you need to configure the Deployment Utility section of the project properties before building the project. Three properties here can be configured to control deployment of your project. Once you configure these properties you can create a package deployment utility by building a project on the computer where the Integration Services project is stored. The build process automatically includes the packages package configurations and miscellaneous files in the project and adds a manifestation file that is gracefully called the Deployment Utility. AllowConfigurationChanges You can assign a True or False value to this property. The True value lets you update configurations during deployment of the package False lets you omit the update option during deployment. You can use this feature when you have to distribute a deployment utility to remote administrators for deploying the project but do not want them to be able to make changes to configurations. This is also useful when you are redeploying packages after making a few changes but do not want configurations to be changed. CreateDeploymentUtility This property also has True or False value options. A True value lets the build process create a deployment utility for the Integration Services project a False value prohibits the creation of deployment utility. You need to specify a True value if you want to create a deployment utility as the default value of this property is False. .
