Join Darryll Petrancuri and I as we present Loading Data Warehouse Partitions with SSIS 2012 Saturday 8 Dec 2012 at SQL Saturday 173 in DC! SQL Server 2012 table partitions offer powerful Big Data solutions to the Data Warehouse ETL Developer. In this presentation, Darryll Petrancuri and Andy Leonard demonstrate one approach to loading ...

The following is an excerpt from SSIS Design Patterns (now available in the UK!) Chapter 7, Flat File Source Patterns. The only planned appearance of all five authors presenting on SSIS Design Patterns is the SSIS Design Patterns day-long pre-conference session at the PASS Summit 2012. Register today. Let’s look at producing a footer row and ...

My fellow authors and I will be presenting a day-long pre-conference session titled SSIS Design Patterns at the PASS Summit 2012 in Seattle Monday 5 Nov 2012! Register to learn patterns for: Package execution Package logging Loading flat file sources Loading XML sources Loading the cloud Dynamic package generation SSIS ...

Samuel Vanga (Blog | @SamuelVanga) has posted a review of our new book SSIS Design Patterns at his blog. Several of Sam’s statements struck me, but none more than this: Within a few hours of reading SQL Server 2012 Integration Services Design Patterns, it stood out that none of the authors were trying to impress by showing what they all know ...

Jessica Moss (blog | @jessicammoss), Michelle Ufford (blog | @sqlfool), Tim Mitchell (blog | @tim_mitchell), Matt Masson (blog | @mattmasson), and me – we are all presenting the SSIS Design Patterns pre-conference session at the PASS Summit 2012! We will be covering material from, and based upon, the book. We will describe and demonstrate ...

I am honored to present Using BIML as an SSIS Design Patterns Engine to the Ohio North SQL Server User Group 1 May 2012! This presentation is based on one of my favorite chapters in the upcoming book: SSIS Design Patterns scheduled for release this summer. If you find yourself in the Cleveland area on the evening of 1 May, please drop by and ...

I have built a beta version of Linchpin People’s SSIS Framework, now including much-requested reports. You can grab the updated copy here. I appreciate any feedback you care to share. :{>

In preparation for SQL Saturday #84 – Kalamazoo,  SQLBits 9, and the PASS Summit 2011; I’ve been honing my presentation called Designing an SSIS Framework. I delivered this presentation a few times over the past couple months. Each time, I promised the attendees I’d send them the code if they emailed me… and a couple things got in the ...

Introduction I am honored to present Designing an SSIS Framework and “I See a Control Flow. Now What?” at SQL Saturday #84 in Kalamazoo Michigan 17 Sep 2011! I See a Control Flow. Now What? This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS ...

I am honored to present Designing an SSIS Framework to Hampton Roads SQL Server and SharePoint Users Group tomorrow, 20 Jul 2011! You can register here. Details: Infotec 100 Constitution Dr Virginia Beach, VA 23462 Wednesday, July 20, 2011 at 6:30 PM (ET) If you read this blog and will be there, introduce yourself! I’m the fat ...