Deploying SSIS Package

Right Click your project, choose properties. Under “Deployment Utility” set the CreateDeploymentUtility to “True”

Next set the below paths.

Build -> OutputPath: D:Program FilesMicrosoft SQL Server SSIS PackagesBin

Deployment Utility -> DeploymentOutputPath: D:Program FilesMicrosoft SQL Server SSIS PackagesBinDeployment

In explorer navigate to your deployment utility folder and double click the “somepackagenameManifest” file.

The wizard will pop and and you can take it from there.

Also, don’t forget, If you modify and update the package, you will need to run the manifest file again.

Cheers

Leave a Reply

Your email address will not be published. Required fields are marked *