Back in June 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 have a calendar reminder that reminds me to check the links every quarter, and that reminder did its job admirably …
Continue reading SSIS Extension Updates – Apr 2026
Category:SSIS
The Day Our SSIS Catalogs Didn’t Match
I knew what I was doing. I wrote the lifecycle management chapter in the Wrox SSIS 2005 book. I implemented SSIS lifecycle management at Unisys. We’d done everything by the book. Well, by the books. This book and this book. In 2013, I led a team that designed an SSIS project that included over 300 …
Continue reading The Day Our SSIS Catalogs Didn’t Match
Fabric SSIS Public Preview: What It Changes – and What It Doesn’t
The conversation around SSIS is heating up again.
Some see the signals and conclude SSIS is on the way out. Others point to the strength of the ecosystem and say it is far from done.
Both perspectives miss something important.
The introduction of Fabric SSIS public preview does not settle the debate. It reframes it.
Announcing: SSIS Lifecycle Advisory
I’ve launched a new fixed-scope advisory offer for organizations running SSIS in production. Many teams do not have an SSIS problem.They have a lifecycle management problem. Deployments feel risky.Change visibility is limited.Governance is inconsistent.Modernization questions keep piling up. The SSIS Lifecycle Advisory is designed to help teams get clear on: deployment and release risk governance …
Continue reading Announcing: SSIS Lifecycle Advisory
SSIS 2016 and SQL Server 2016 End-of-Life 14 Jul 2026
A tip o’ the hat to Brent Ozar who included a link in his 9 Feb 2026 newsletter to the SQLFingers post titled “SQL Server 2016 Ends in July. Here’s What Will Break.“ Regarding SQL Server 2016, SQLFingers says: After July 14, 2026: No more security patches No more support calls No longer compliant You …
Continue reading SSIS 2016 and SQL Server 2016 End-of-Life 14 Jul 2026
Upgrading from SSIS – Can We Talk?
A Tale of Two Worlds At the outset of 2026, I live in two worlds. I continue to support clients who use SSIS for enterprise data engineering. Some of the enterprises are small-ish by comparison. Others are huge. Some friends also continue to support these clients and clients like them. That’s World 1. World 2 …
Continue reading Upgrading from SSIS – Can We Talk?
Separating Concerns in SSIS
I recently read a social media post from a data engineer that I found both encouraging and heartbreaking. This data engineer shared that he used an AI engine to successfully convert an SSIS package, roughly 1MB in size, into a different data engineering platform. Why encouraging? First, it is genuinely encouraging that AI engines are …
Continue reading Separating Concerns in SSIS
Create a SQL Server 2025 SSIS Catalog Using SSMS v22
In this post, I describe how to create an SSIS Catalog in SQL Server 2025 (RC) using SSMS v22 (Preview 3). Once configured, I describe how to test the installation using Visual Studio 2026 Insiders Community Edition. In earlier posts, I describe prerequisites: One Way to Install SQL Server 2025 One Way to Install SSMS …
Continue reading Create a SQL Server 2025 SSIS Catalog Using SSMS v22
Add the SSIS Extension to Visual Studio 2026 Insiders
In this post, I explain how to add the Integration Services extension to Visual Studio 2026 Insiders Community Edition. First, install Visual Studio 2026 Insiders Community Edition. Then… Add the SQL Server Integration Services Projects 2022+ Extension There is a lot of exciting news to announce! SSIS Extension Renamed First, the SSIS extension for Visual …
Continue reading Add the SSIS Extension to Visual Studio 2026 Insiders
SSIS Extension Updates – Jun 2025
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 …
Continue reading SSIS Extension Updates – Jun 2025