What’s the Best Book for Learning SSIS?

I am often asked the question, “Andy, what’s the Best Book for Learning SSIS?” There are some really good books out there that will help you learn SSIS (and I am co-author of several). The book from which I learned the most about SSIS is Extending SSIS 2005 with Script by Donald Farmer. Why do …
Continue reading What’s the Best Book for Learning SSIS?

The Recording for Use SSIS Catalog Compare to Lift and Shift SSIS to ADF is Available

The recording for the Summer-O’-ADF webinar titled Use SSIS Catalog Compare to Lift and Shift SSIS to ADF is now available (registration required)! Abstract SSIS Catalog Compare facilitates DevOps for enterprise SSIS, saves time, improves code quality, and lifts and shifts SSIS projects to Azure Data Factory’s Integration Runtime. More than just an “Package / …
Continue reading The Recording for Use SSIS Catalog Compare to Lift and Shift SSIS to ADF is Available

SSIS Catalog Compare vNext Preview

I am happy to announce that the next version of SSIS Catalog Compare is officially in Preview! What exactly does “Preview” mean? I’m glad you asked. It means I am sharing copies of SSIS Catalog Compare with users of the current version to get their feedback, find bugs, and help identify improvements. Here’s a screenshot: …
Continue reading SSIS Catalog Compare vNext Preview

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

Free Webinar – ADF Controller Design Pattern with the SSIS Integration Runtime

The next free webinar in my Summer-O’-ADF series of free webinars is titled ADF Controller Design Pattern with the SSIS Integration Runtime. It’s scheduled for Thursday 5 Jul 2018 at noon EDT. It will be recorded in case you miss it. “Previously on the Summer-O’-ADF Series…” </DonLaFontaine> In my previous webinar, The Azure Data Factory Controller Design …
Continue reading Free Webinar – ADF Controller Design Pattern with the SSIS Integration Runtime

100 Dumb Little Things

Software development is hard. It takes time, yes. But more than that, software development takes patience and thought and blood and sweat and love and tears. My friends at Varigence recently released an update to their Business Intelligence Markup Language (Biml) products. If you’re into business intelligence or data science, integration, or engineering, you should …
Continue reading 100 Dumb Little Things

Free Webinar – The Azure Data Factory Controller Design Pattern – 28 Jun

Andy’s Summer-o’-ADF continues with another free (yes, FREE) webinar!   Abstract Join me as I begin to explore a brand new topic: Azure Data Factory Design Patterns. This first webinar in the series is titled The Azure Data Factory Controller Design Pattern. In this demo-tastic session I show how to apply the pattern described in …
Continue reading Free Webinar – The Azure Data Factory Controller Design Pattern – 28 Jun

The Recording for Introduction to Lifting and Shifting SSIS to the Cloud is Now Available

  The recording of my free webinar – Introduction to Lifting and Shifting SSIS to the Cloud – is now available (registration required). Abstract How does an enterprise lift and shift SSIS projects from SSIS Catalogs on-premises to the Azure Data Factory Integration Runtime? What are the best practices? Do SSIS lifecycle management tools exist to …
Continue reading The Recording for Introduction to Lifting and Shifting SSIS to the Cloud is Now Available

ADF Execute SSIS Package Activity

The good people who work on Azure Data Factory recently added an Execute SSIS Package activity. It’s pretty cool. Let’s tinker with it some, shall we? First, you will need to create an Azure Data Factory SSIS Integration Runtime. If you don’t know how, that’s ok – I’ve written a post titled Lift and Shift SSIS …
Continue reading ADF Execute SSIS Package Activity