Deploying SSIS Project with Multiple Packages to SSISDB

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.

Note:

• 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.