Deploying packages to SQL Server from SSDT is straightforward. We can either deploy the project or an individual SSIS Package i.e. Project Deployment or Package Deployment. (SQL Server 2016 Onwards).
Here we will see the package deployment.
Right-click the package that we would like to deploy and select Deploy Package.
This opens the Integration Services Deployment Wizard
Click on Next and Specify Server Name and the credentials to connect to the SQL Server an click on Connect.
For the…
Continue Reading Nishant Rana’s Article on their blog
Deploying Package to SQL Server Integration Services Catalog (SSISDB) from Visual Studio (SSDT) – Nishant Rana’s Weblog
Blog Syndicated with Nishant Rana’s Permission