Monday 11 May 2015

What is Deployment utility in SSIS

               Deployment utility is used to move the packages from one place to another place same as import/export package features in SQL Server Management Studio. The deployment utility is a folder that contains the files you need to deploy the packages in an Integration Services project on a different server.

                   When u builds the project, all packages and package dependencies (like configuration, Manifest files) are automatically included.

To create a package deployment utility as follows
Steps :
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 Property Pages dialog box, click Deployment Utility.
The following table lists the deployment utility properties.

Property
Description
AllowConfigurationChange
A value that specifies whether configurations can be updated during deployment.
CreateDeploymentUtility
A value that specifies whether a package deployment utility is created when the project is built. This property must be True to create a deployment utility.
DeploymentOutputPath
The location, relative to the Integration Services project, of the 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 DeploymentOutput Path 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.

Note: You can see the packages in the above diagram at Deployment Output path.

Let me know what you think about this article.


No comments:

Post a Comment