Deploy SSIS Package To SQL Server

Note
Before going next, first make sure you have SQL Server Integration Services installed.
 
Open Visual Studio SSIS package project and right click on project and hit Deploy to deploy all packages, if you want to install individual packages then right click on the package and hit deploy.
 
Deploy SSIS Package To SQL Server
 
First window is introduction windows click Next button.
 
Deploy SSIS Package To SQL Server
 
We have two deployment targets,
  • SSIS in SQL Server
  • SSIS in Azure Data Factory
As in this article we are going to deploy on SQL Server, so we must select SSIS in SQL Server and click Next.
 
Deploy SSIS Package To SQL Server
 
Select destination, Enter SQL Server name, Authentication type, Username and password and click Connect. Once connect Browse project folder path if available, if not available create a directory in SSISDB and create a new project and hit Next.
 
Deploy SSIS Package To SQL Server
 
You can review all given changes and hit Deploy.
 
Deploy SSIS Package To SQL Server
 
You can check the deployment result in last windows. If all results are passed, then click close.
 
Deploy SSIS Package To SQL Server
 
Above screenshot shows that all results are passed and successfully deployed.
 
Deploy SSIS Package To SQL Server
 
Go to SQL Server and expand Integration Services Catalogs and go to SSISDB the you can see the created folder and project and deployed packages there.
 

Conclusion


In this article, we have learned how to deploy SSIS Project to SQL Server.