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
Category:DILM
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
Use SSIS Framework Manager to Build an SSIS Application
The Data Integration Lifecycle Management Suite (DILM Suite) is a collection of tools designed to reduce the friction of managing SQL Server Integration Services (SSIS) across its lifecycle. The SSIS Framework is a core element of DILM Suite. About DILM Suite DILM Suite helps enterprise data engineers and data teams compare, package, deploy, and maintain …
Continue reading Use SSIS Framework Manager to Build an SSIS Application
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
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
Announcing SSIS Catalog Browser v0.9.20
Kent Bradshaw and I are excited to announce the availability of SSIS Catalog Browser v0.9.20! SSIS Catalog Browser is free and surfaces SSIS Catalog projects and configurations metadata in a single unified view. The latest version fixed a handful of bugs, improved load query efficiency, and fixed duplication and misplacement of reference mappings in project and …
Continue reading Announcing SSIS Catalog Browser v0.9.20
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
Announcing Data Engineering Fridays!
I’m excited to announce Data Engineering Fridays! I can hear some of you thinking, … “What are Data Engineering Fridays, Andy?” That’s an awesome question! I’m glad you asked. Data Engineering Fridays is a weekly stream, between 24 May and 23 Aug 2024, in which I lead a discussion about data engineering-related topics. The 24 …
Continue reading Announcing Data Engineering Fridays!
SSIS Catalog Browser v0.9.14.0 is Available
I am honored to announce the latest version of SSIS Catalog Browser is available for (free!) download. Updates in v0.9.14.0: Bug fixes. No longer mixing package parameter references with project parameter references in the Values Everywhere feature. Check it out today! Want to Learn Azure Data Factory (from me)? I’m delivering a full day of …
Continue reading SSIS Catalog Browser v0.9.14.0 is Available