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?
Category:SSIS
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
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 – Dec 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 third quarterly update. There Are Two Integration Services Extensions I’m not sure why the decision was made …
Continue reading SSIS Extension Updates – Dec 2024
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
Potential Danger Using Deploy Package with SSIS 2016
I… tweeted? X’d?… this message 11 Jul 2024. As promised, here’s the public post. If you want to skip some history mixed with the description of EDNA’s SSIS framework, feel free to go to the section labeled “Imagine My Surprise…” Some Back Story I have a long and storied history with frameworks. My ETL frameworks …
Continue reading Potential Danger Using Deploy Package with SSIS 2016