I coauthored my 15th book Together with Christian Cote (lead author) and Matija Lah (coauthor) we publishes SQL Server 2017 Integration Services Cookbook. Of course, it is kind of early to say this is a definitive guide to SSIS 2017. More accurate name would be SSIS 2016 / 2017 Cookbook. Besides detailed guidelines how to use the 2016 version, you ...

My latest article, Help for DBAs Who Support SSIS… is now live at SQL Server Central! In this article I share some tips and tricks for using SSIS Catalog Compare for surfacing SSIS Catalog metadata, comparing SSIS projects deployed to different SSIS Catalog, and Scripting SSIS Catalog configurations metadata (such as Environments, Environment ...

My next book titled Building Custom Tasks for SQL Server Integration Services is available for pre-order! The current release date is scheduled for late July 2017. The Cost of Custom SSIS Tasks There is overhead associated with using custom tasks in SSIS. When I started writing, I believed there were three costs associated with custom SSIS ...

I am honored to present my day-long precon titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration at SQL Saturday 620 – Dublin 15 Jun 2017! Description What is Intelligent Data Integration? SSIS packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM, produced ...

I’m writing about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages in their enterprises. Earlier I wrote Schedule an SSIS Application with SSIS Framework Community Edition, a post that describes using SQL Server Agent to schedule the execution of an SSIS ...

I’m writing more about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages – called SSIS Applications – in their enterprises. Earlier I wrote Schedule an SSIS Application with SSIS Framework Community Edition, a post that describes using SQL Server Agent to ...

The coolest thing about SSIS Framework Community Edition is it’s free. You can click that link to head over to the DILM Suite site where you can learn more and find a link to the source code, documentation, and sample SSIS projects on GitHub. I’m overwhelmed by the number of folks using this free utility. Believe it or not, there are a handful ...

I’m honored to present Use Biml as an SSIS Design Patterns Engine at SQL Saturday #588 in New York City 20 May 2017! I’ve been looking at the event schedule and… WOW! There are a lot of smart people presenting – plus me! I hope to see you there. :{>

Kent Bradshaw and I had a great crowd, lots of awesome questions, and delivered good demonstrations at the Designing an SSIS Framework webinar. You can now view the webinar for free (although registration is required) here. In the webinar Kent and I discussed the following Data Integration Lifecycle Management Suite products: SSIS Framework ...

I am honored to present Intelligent Data Integration – a day-long precon at SQL Saturday #643 in Louisville Kentucky 4 Aug 2017! Synopsis: What is Intelligent Data Integration? SSIS packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM, produced using Biml and executed using an ...