1. Copy SSIS package file (.dtsx) to server.
  2. Run xxxxxx.SSISDeploymentManifest file to start the Package Installation Wizard.
  3. Make sure the configuration file xxxxxxConfig.xml also exist in the same folder. The Package Installation Wizard will look for this file for configuration setup.

Deployment with this method will set the database connection string.

SSIS Package deployment using SSIS deployment manifest file seems to be the most reliable and trouble free way.

Note: If you are updating an existing package, first open up SSMS Integration Service to check the existing folder path of the package. Point the new package to this folder path.

Package Installation Wizard

  • Click on the .SSISDeploymentManifest file to start the Package Installing Wizard
  • Select server to deploy, select folder path to deploy.
  • Select location on server to deploy. (Leave as is).

Last modified: December 1, 2023

Author

Comments

Write a Reply or Comment