Back in Jun 2024, I announced I was changing the way I report updates to the SQL Server Integration Services extension for Visual Studio (in a post titled SSIS Extension Updates – Jun 2024). I skipped the Mar 2025 update as there were no changes to report. I have a calendar reminder that reminds me to check the links every quarter, and that reminder did its job admirably earlier this month, but there were still changes to report.

Thankfully, I caught updates in this past week’s Microsoft Community Hub Weekly Digest email, which is a handy way to keep up with changes and announcements regarding Microsoft technology of interest.

There Are Two Integration Services Extensions

I’m not sure why the decision was made to “fork” development and maintenance of the Integration Services extension for Visual Studio 2022. Based upon experience with SSIS, Visual Studio, and the Microsoft SSIS team, I am confident there’s a very good reason. The links to each extension are:

SSIS Pre-2022: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects&ssr=false#overview
SSIS 2022: https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices

Visiting the SQL Server Integration Services Projects page reveals no updates to the pre-2022 SSIS extension since my previous post on the topic:

The latest update is version 4.6, released 21 Mar 2024.

New:

• IS Deployment Wizard supports Azure Active Directory… er, I mean Entra, authentication.
• Dimension and Partition Processing components are supported.

Bug fixes:

• A notification to “Repair Microsoft Visual Studio Tools for Applications 2019 via Control Panel” was added when developers encounter a failure of scripting to update. The past few updates have addressed bugs related to scripting in SSIS.
• An exception when converting to Project Deployment Model. Project Deployment Model is necessary for deployment to the SSIS Catalog, and conversion to Project Deployment Model supports backwards compatibility with SSIS projects developed using Package Deployment Model. Package Deployment Model was the only deployment model available in pre-2012 versions of SSIS. Project Deployment Model has been the default setting for new SSIS project development since SSIS 2012.

SSIS 2022 Update

A new update is available for the SQL Server Integration Services Projects 2022:

The latest update is version 1.6, released 23 Jun 2025.

Bug fixes:

• Fixed side-by-side issue with SSMS 21.2.5 and SSMS 21.3.6.
• Addressed NVD – CVE-2025-29803 related to Visual Studio Tools for Applications 2022.
• Fixed the error 0x80040e51 that occurred when previewing data using the Oracle provider for OLEDB while connecting to an Oracle database.

Known issues:

• In the context menu (right mouse button) on objects in the project (e.g., the solution, a package) in Visual Studio, many of the entries appear many times.
• DQS has side-by-side issue when target SQL Server Version is 2017 and 2019 when SQL Server engine installed at the same machine.” If I’m reading this correctly, DQS experiences some issue when multiple versions of SQL Server are installed on the same server. I’ve never been a fan of installing multiple versions of SQL Server on the same server. I highly recommend SSIS developers not attempt to install different versions of SSIS on the same server. It’s “bad.”

Conclusion

Lots of enterprises continue to use SSIS – especially for on-premises data engineering. In a recent conversation with Enterprise Data & Analytics data engineers, we surmised SSIS may likely remain available for as long as SQL Server is supported on-premises.

It’s a guess, yes; but an educated and somewhat informed guess.