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
Tag:SSIS
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?
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
Coming Soon – SSIS Framework Manager
On 9 Sep 2025, I posted a short video about SSIS Framework Manager, software I’ve dreamed about building for, well, for a long time now: I’m excited to reach this milestone! Reaching it has been quite the journey. I share more of the story in my newsletter titled “An SSIS Framework Odyssey: It’s taken a …
Continue reading Coming Soon – SSIS Framework Manager
Getting Started with the SSIS Catalog in SSMS v21
SQL Server Integration Services (SSIS) is available in preview in SQL Server Management Studio v21.2.5. Here’s how to configure SSMS get started using the SSIS Catalog! Install or Update, then Modify, SSMS If you have not installed SQL Server Management Studio v21, you can grab the latest installation bits here. If you have already installed …
Continue reading Getting Started with the SSIS Catalog in SSMS v21
SSMS v21 and SSIS
Regular readers of this blog know I am a fan of Star Trek. In fact, my beautiful bride and I recently finished streaming Star Trek: Deep Space 9. It was the first time either of us had watched the series start-to-finish and we enjoyed the characters and story lines. It is well-written. We agreed Worf’s …
Continue reading SSMS v21 and SSIS
SSIS Extension Updates – Sep 2024
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). Right on time, here’s the second quarterly update. There Are Two Integration Services Extensions I’m not sure why the decision was …
Continue reading SSIS Extension Updates – Sep 2024