Updates to Stairway to Integration Services

The Stairway to integration Services has been updated! I added content to Step 1 to provide more detail about creating a first SSIS project and corrected a typo in Step 2 that referred to an older name for the Step 1 article. I also made the corrected Step 1 article name a link to help. …
Continue reading Updates to Stairway to Integration Services

SSIS Design Pattern: Producing a Footer Row

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 …
Continue reading SSIS Design Pattern: Producing a Footer Row

Join the Authors of SSIS Design Patterns at the PASS Summit 2012!

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 Frameworks Data warehouse ETL Data …
Continue reading Join the Authors of SSIS Design Patterns at the PASS Summit 2012!

SSIS Training 15-19 Oct in Reston Virginia

Early bird registration is now open for Linchpin People’s SSIS training course From Zero To SSIS scheduled for 15-19 Oct 2012 in Reston Virginia! Register today – the early bird discount ends 28 Sep 2012. Training Description From Zero to SSIS was developed by Andy Leonard to train technology professionals in the fine art of …
Continue reading SSIS Training 15-19 Oct in Reston Virginia

Book Review: SSIS Design Patterns

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 …
Continue reading Book Review: SSIS Design Patterns

New Book! SQL Server 2012 Integration Services Design Patterns!

SQL Server 2012 Integration Services Design Patterns has been released! The book is done and available thanks to the hard work and dedication of a great crew: Michelle Ufford (Blog | @sqlfool) – co-author Jessica M. Moss (Blog | @jessicammoss) – co-author Tim Mitchell (Blog | @tim_mitchell) – co-author Matt Masson (Blog | @mattmasson) – …
Continue reading New Book! SQL Server 2012 Integration Services Design Patterns!