Recently, I was developing an SSIS package that read from an Azure SQL DB table and wrote to an on-premises SQL Server 2025 database table. I encountered the following error: [ADO NET Source [41]] Error: ADO NET Source has failed to acquire the connection {<ConnectionManagerGUID>} with the following error message: “Could not load file or …
Continue reading SSIS 2025 Microsoft.Data.SqlClient Connection Error
Tag:SSIS
Microsoft Just Made SSIS-to-Fabric Easier
Upcoming Live Training A Day of Fabric Data Factory | 19 May 2026 | Live online, 9:00 AM to 4:30 PM EDT Registration closes 16 May 2026 Register → Here’s what “easier” means Your SSIS packages still pay the bills. They’ve earned that. The orchestration logic, the error handling, the parameter discipline, the framework patterns …
Continue reading Microsoft Just Made SSIS-to-Fabric Easier
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?
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