- Copy .ISPAC file to the server.
- Click on the .ISPAC file on the server, this should bring up the Integration Services Deployment Wizard.
- Select packages and deployment server to deploy SSIS packages.
Note
.ISPAC file is generated in the bin\Development folder of Visual Studio project.
SSIS Package deployment using .ISPAC file seems to be the most reliable and trouble free way.
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.
Comments