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
Tag:DILM
SSIS Extension Updates – Apr 2026
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
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.
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
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 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
Confidence and SSIS Catalog as Code
That’s what we sell at Data Integration Lifecycle Management Suite: confidence. Confidence There’s no substitute for that feeling of confidence when SSIS Catalog Compare is used to compare two SSIS Catalogs and the comparison yields no differences. I cannot improve on testimonies from our customers: The question of comparing a Production SSIS Catalog with a …
Continue reading Confidence and SSIS Catalog as Code
SSIS Catalog Compare Code Promotion with DILM Deployment Utility
This post is a follow-up to my recent post titled Promoting SSIS Catalog Objects Between Lifecycle Management Tiers. DILM Deployment Utility is a great way to encapsulate SSIS Catalog folders as code in sccpac files. Drop the files in a git repo, add, commit, and push, and viola, scripts for your SSIS Catalog folder(s) and …
Continue reading SSIS Catalog Compare Code Promotion with DILM Deployment Utility
Promoting SSIS Catalog Objects Between Lifecycle Management Tiers
Code promotion is essential to DevOps. One problem solved by SSIS Catalog Compare is code promotion via scripting between Development, Test, Pre-Production, and Production lifecycle management tiers*. In the video, I demonstrate: One gap (scripting all SSIS objects stored in the SSIS Catalog) in SSIS management tools shipped with SSMS. One way SSIS Catalog Compare …
Continue reading Promoting SSIS Catalog Objects Between Lifecycle Management Tiers
SSIS Catalog Compare August Sale
For the month of August 2022, SSIS Catalog Compare Enterprise Edition yearly subscription is on sale for 60% off the regular yearly subscription rate! SSIS Catalog Compare facilitates Data Integration Lifecycle Management (DILM) and DevOps with SSIS by: Comparing SSIS Catalog metadata between data integration lifecycle tiers (Development, Test, QA, Production, etc.) Promoting (deploying) SSIS …
Continue reading SSIS Catalog Compare August Sale