Author:Andy Leonard

Join me 28 Mar 2016 at 1:00 PM EDT for DILM with Catalog Compare – another (FREE!) webinar from Enterprise Data & Analytics! DILM (Data Integration Lifecycle Management) is how data integration is done in the modern DevOps enterprise. Join Andy Leonard, Data Philosopher at Enterprise Data & Analytics, for a look at a helpful …
Continue reading Free Webinar 28 Mar at 1:00 PM EDT – DILM with Catalog Compare

You can view the recording for Biml 201: Batched Incremental Load in the SSIS Framework – a free webinar from Enterprise Data & Analytics (registration required). The source code is available here. Enjoy! :{> Next webinar: DILM with Catalog Compare – 28 Mar 2016, 1:00 PM EDT. Register today!

Join me 7 Mar 2016 at 12:00 PM ET for a (FREE!) webinar titled Biml 201: Batched Incremental Load in the SSIS Framework. While delivering the (FREE!) webinar titled SSIS Framework Community Edition, my friend John Sterrett (blog | @johnsterrett) asked about using Biml to generate SSIS packages that execute in an SSIS Framework like …
Continue reading Free Webinar–“Biml 201: Batched Incremental Load in the SSIS Framework” 7 Mar

The recording for the free webinar titled Introducing SSIS Framework Community Edition is now available! Registration is required. You may download the code and documentation here. Enjoy! :{>

The recording for the webinar titled Easy SSIS Migration with SSIS Catalog Compare is now available! Enjoy! :{>

There’s a back-story to my post titled SSIS 2016 CTP 3 and Data Flow Column LineageID. I’ll get to the story in a minute, but first I’d like to say that every company has excellent customer service. You don’t believe me? Ask them, “Company, do you have excellent customer service?” They will all answer, “Yes. …
Continue reading Microsoft is Listening

Back When We Used to Carve Our Own Chips Out of Wood… Back in the old days (2005), SSIS Data Flow LineageIDs were created at design-time. Here’s a screenshot of an SSIS 2005 package’s XML: When an error occurred, the ID property of the column in error was supplied to the ErrorColumn column field of …
Continue reading SSIS 2016 CTP 3 and Data Flow Column LineageID

I’m happy to pass along the news that my friend Cathrine Wilhelmsen (blog | @cathrinew) has been recognized as a BimlHero! Congratulations, Cathrine! You can learn more about Biml from Cathrine and Scott Currie at SQLBits in May 2016. On 4 May, Scott and Cathrine deliver a full day of Biml training titled Learn Biml …
Continue reading Congratulations to BimlHero Cathrine Wilhelmsen!

Unless you live under a rock, you’ve seen the buzz about Data Lakes, Big Data, Data Mining, Cloud-tech, and Machine Learning. I watch and read reports from two perspectives: technical and as a consultant. As a Consultant If you watch CNBC, you won’t hear discussions about ETL Incremental Load or Slowly Changing Dimensions Design Patterns. …
Continue reading Data Integration is the Foundation

I gathered recently with some friends who are geeks to discuss geeky stuff. As is often the case, there were a lot of “what if” questions, and we answered most of them by firing up laptops and VMs for testing. I had some trouble with my VM running my instance of the December preview running …
Continue reading Deploying a Single Package First in SSIS 2016