Category:Uncategorized

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

The recording for the Enterprise Data & Analytics webinar “DILM DevOps: SSIS Frameworks + Design Patterns” is available here. It’s free! But registration is required. Enjoy! :{>

First, thanks to everyone who has attended one of my free webinars! I enjoy delivering training and hope that it shows. Where can you learn about upcoming training from me? At the Enterprise Data & Analytics Training page, of course. Upcoming training January 20 – Free Webcast: DILM DevOps: SSIS Frameworks + Design Patterns January 27 …
Continue reading More Training from Andy Leonard!

The Biml 103 webinar “Automating SSIS Design Patterns with Biml” recording is now available. Registration is required, but it’s free. Enjoy! :{>