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.