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. DILM Suite helps enterprise data engineers and data teams compare, package, deploy, and maintain SSIS solutions with greater consistency, visibility, and control by replacing manual, error-prone processes …
Continue reading Use SSIS Framework Manager to Build an SSIS Application
Tag:DevOps
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 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
Using DILM Deployment Utility to Restore SSIS Catalog Folders
In this video, I demonstrate using DILM Deployment Utility 2022 – part of SSIS Catalog Compare 2022 Enterprise Edition – to restore the contents of an SSIS Catalog folder in a disaster recovery scenario. Question? Want to learn more? Please contact me. Enjoy! :{>
SSIS Framework Manager Updated
I am so excited to announce scripting in SSIS Framework Manager – a new component of the Data Integration Lifecycle Management Suite – is code complete! My first-pass testing worked really well, so I decided to go live on LinkedIn Live and demonstrate it. I practiced a few test-walk-throughs and it all worked. As is …
Continue reading SSIS Framework Manager Updated
Azure DevOps, Git, and SSIS
After a couple false starts, I was able to live-stream one way to use Azure DevOps with Git to source-control the contents of an SSIS Catalog folder – including SSIS Catalog Folder, Projects, Packages, Environments, Environment Variables, Configured Literals, References, and Reference Mappings. In the video, I create an Azure DevOps project configured to use …
Continue reading Azure DevOps, Git, and SSIS
How I Build an SSIS Test Virtual Machine
I use VirtualBox for my hypervisor engine. I started using it years ago when it was the first free hypervisor I found that supported 64-bit guests. In this post I share some thoughts about testing SSIS using a test virtual machine (VM). There are other awesome hypervisor platforms out there. In setting up a virtual …
Continue reading How I Build an SSIS Test Virtual Machine
Two Recordings Available: SSIS Catalog and SSIS Lifecycle
Andy Leonard shares two recordings about using the SSIS Catalog to manage enterprise data engineering.
You Might Need an SSIS Framework
You might need an SSIS framework. “How can I tell if I need an SSIS framework, Andy?” I’m glad you asked. Does your enterprise: Practice DevOps? Execute lots of SQL Server Integration Services (SSIS) packages? Execute SSIS packages several times per day? Execute “SSIS in the Cloud” using the Azure Data Factory version 2 Integration …
Continue reading You Might Need an SSIS Framework