1. Copy .ISPAC file to the server.
  2. Click on the .ISPAC file on the server, this should bring up the Integration Services Deployment Wizard.
  3. Select packages and deployment server to deploy SSIS packages.

Note

.ISPAC file is generated in the bin\Development folder of Visual Studio project.

Deployment using .ispace file is much easier than deploying the SSIS package via SSMS Integration Services Catalogs package deployment.

You can also deploy direct from Visual Studio to SSIS in SQL Server.

Last modified: November 12, 2021

Author

Comments

Write a Reply or Comment