Create SSIS package deployment utility

Since this option is not very obvious, I have included here for future reference.

  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.
Leave a comment

0 Comments.

Leave a Reply

You must be logged in to post a comment.