Announcing Biml Academy!

You can access Biml Academy recordings and more at the Biml Academy website! Announcing Enterprise Data & Analytics Biml Academy – 5 Days of Free Training – 9-13 May! Welcome to Biml Academy! Join me for a five-day online event and learn Biml now! [Recording] Biml Academy – Lesson 0 – SSIS Design Patterns – …
Continue reading Announcing Biml Academy!

Free Webinar 28 Mar at 1:00 PM EDT – DILM with Catalog Compare

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

Recording Available for “Biml 201: Batched Incremental Load in the SSIS Framework”

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!

Free Webinar–“Biml 201: Batched Incremental Load in the SSIS Framework” 7 Mar

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

Microsoft is Listening

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

SSIS 2016 CTP 3 and Data Flow Column LineageID

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