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

Note:

  • 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: September 3, 2021

Author

Comments

Write a Reply or Comment