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.
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
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
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
On 08 Jan 2026, I recorded this video of me using Claude Code to “one-shot” the development of a Windows application. What does one-shot mean? Andy’s definition: A one-shot is when a developer interacts with AI and the results are generated correctly on the first attempt. Enjoy!
Stephen and I are honored to present a full day of training titled Using AI To Be Your Data Engineering Partner in-person 01 May 2026 at Day of Data Jax 2026! Abstract Stop building pipelines the slow way. AI is transforming data engineering, and the gap between those who’ve adapted and those who haven’t is …
Continue reading Honored to Present Using AI To Be Your Data Engineering Partner at Day of Data Jax 2026
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?
All the cool kids are writing year-in-review posts. I reckon I’ll write this one. For me, 2025 has been a year filled with different. Some of the different has been very cool; some has not been cool at all. If you’ve stumbled onto this post / newsletter (I’m writing this on my blog at andyleonard.blog …
Continue reading 2025: A Number Containing Two 2’s, One 5, and a 0
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
The following is an excerpt from a 200+ page document titled AI-Assisted Data Engineering Development Playbook: How I Set Up a Virtual Server (Virtual Machine) for Modern Data Engineering for sale at DELMSuite.com, but available – free – to paid subscribers of my newsletter: Engineer of Data. The phrases context fatigue, attention degradation, instruction drift, …
Continue reading Install Durandal Memory MCP Server to Mitigate AI Context Fatigue
