• Article

How to: Create an Integration Services Package Deployment Utility

SQL Server Integration Services packages can be deployed by using a deployment utility, by using the import and export package features in SQL Server Management Studio, or by saving a copy of the package in Business Intelligence Development Studio. However, only the deployment utility can deploy multiple packages. The deployment utility also automatically includes the package dependencies (for example, configurations) and the files that contain supporting information (for example, documentation).

Note

To become better acquainted with the concepts explained in this section, see Tutorial: Deploying Packages.

To create a package deployment utility

  1. In Business Intelligence Development Studio, open the solution that contains the Integration Services project for which you want to create a package deployment utility.

  2. Right-click the project and click Properties.

  3. In the <project name> Property Pages dialog box, click Deployment Utility.

  4. To update package configurations when packages are deployed, set AllowConfigurationChanges to True.

  5. Set CreateDeploymentUtility to True.

  6. Optionally, update the location of the deployment utility by modifying the DeploymentOutputPath property.

  7. Click OK.

  8. In Solution Explorer, right-click the project, and then click Build.

  9. View the build progress and build errors in the Output window.