Free Webinar – Designing a Custom ADF SSIS Execution Framework

Folks, I’m not going to even pretend to be cool and collected about this webinar about designing an ADF SSIS Execution Framework. I’ve been waiting for this one for a loooooooong time! The next (free!) webinar in the series I’m calling the Summer-O’-ADF is Designing a Custom ADF SSIS Execution Framework. It’s at noon EDT Thursday …
Continue reading Free Webinar – Designing a Custom ADF SSIS Execution Framework

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

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

My Books

I’ve authored and co-authored a bunch of books! Truth be told, I enjoy writing. I think my love of writing stems from a love of learning. I’m just trying to share the joy! It’s a huge honor to write. I’m humbled and thrilled (all at the same time – a feeling I describe as “all …
Continue reading My Books

Introduction to the SSIS Lifecycle – 7 Jun 2018

Join me Thursday, 07 Jun at noon EDT for a free webinar: Introduction to the SSIS Lifecycle! How should an enterprise promote SSIS projects from Development to Production? How many “levels” are required? What are the best practices? Do SSIS lifecycle management tools exist? Join Andy Leonard – SSIS author, trainer, and consultant – to …
Continue reading Introduction to the SSIS Lifecycle – 7 Jun 2018

Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018

Join me Thursday, 24 May for a free webinar: Introduction to Configuring SSIS in the SSIS Catalog! The SSIS Catalog is a flexible data integration framework. What’s wrong with that last sentence? “Flexible” is dual-edged – it means there’s some complexity. Fear not! Andy Leonard – SSIS author, trainer, and consultant – is here to …
Continue reading Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018

My Learning Resources for SSIS

People often ask me, “Andy, where can I learn SSIS or learn more about it?” Well, you’re at one such location – my blog! I’ve been blogging about SSIS for about 10 years as I type this. There’s a lot posts here about SSIS – that’s the good news. The bad news is: There’s a …
Continue reading My Learning Resources for SSIS

Why I Built SSIS Catalog Compare, by Andy Leonard

A few weeks ago I published a blog post titled Why I Built DILM Suite, by Andy Leonard – an excerpt from the book Data Integration Life Cycle Management with SSIS. This post is another excerpt of the same book. In fact, this is the chapter that follows the chapter on Catalog Browser (which is …
Continue reading Why I Built SSIS Catalog Compare, by Andy Leonard

Honored to Present an SSIS and ADF Precon at Data Platform Summit 2018!

I am honored to announce I have been selected to deliver a full-day precon titled A Day of Intelligent Data Integration with SSIS and ADF at the Data Platform Summit 2018 in Bengarulu, India 7 Aug 2018! This will be my first appearance at the Data Platform Summit and my first visit to India. I …
Continue reading Honored to Present an SSIS and ADF Precon at Data Platform Summit 2018!

Parallel Execution in SSIS Framework Community Edition

A number of folks are using the SSIS Framework Community Edition. I know because I continue to get interesting questions about it! Before I write more, I’d like to invite users to the DILM Suite Slack channel for Community Edition. If you cannot join, please let me know (andy.leonard@dilmsuite.com) and I will invite you! For …
Continue reading Parallel Execution in SSIS Framework Community Edition