A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Hi @Barr, David
I would recommend reverting back to VS2022.
VS2026 is too raw, more precisely its SQL Server Integration Service extension.
Workaround (bypass Visual Studio UI)
You can deploy the built .ispac outside Visual Studio using the Integration Services Deployment Wizard. This avoids the VS shell and the extension entirely:
- Build your SSIS project to produce an
.ispac(from VS: Build → Build or Rebuild). - Run the wizard directly:
ISDeploymentWizard.exe(typically underC:\Program Files\Microsoft SQL Server\16x\DTS\Binn\ or c:\Program Files\Microsoft SQL Server Management Studio 22\Release\Common7\IDE\CommonExtensions\Microsoft\SSIS\170\Binn\) and point it at your.ispac.