How to: Create an Integration Services Package Deployment Utility

SQL Server 2005 Integration Services (SSIS) 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).


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

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.

See Also


Importing and Exporting Packages
Saving Packages

Other Resources

Deploying Integration Services Packages
Deployment How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance