Copy SSIS package file source to deployment server.

Via SSMS, Navigate to Integration Services Catalogs -> SSISDB -> <Specific Project> -> right click and Deploy Packages

This should open up the “Integration Services” Deployment Wizard

Select the root folder where the Visual Studio project files resides with the package files.


  • You might need to run SSMS in “Run as administrator” mode.
  • You can choose to deploy all packages or a specific package.
  • All package must pass the validation test in order to be deployed.
  • Configuration settings set at the SQL job level will override configuration settings set in the package.

Last modified: November 11, 2021



Write a Reply or Comment