Design Patterns

Learn more about SSIS Design Patterns at the 2012 PASS Summit

Learn more about SSIS Design Patterns at the 2012 PASS Summit

We managed to bring together the entire author team for the SSIS Design Patterns book to run a pre-conference event at the 2012 PASS Summit. I posted about this when it was first announced, but since our book came out today, I thought it would be a good time to post a reminder. We’ve been … Continued

SQL Server 2012 Integration Services Design Patterns comes out tomorrow!

SQL Server 2012 Integration Services Design Patterns comes out tomorrow!

My first SSIS book – SQL Server 2012 Integration Services Design Patterns (Apress) – will be released tomorrow (9/5). In addition to some of the design patterns that I typically talk about in my presentations, it has some great content from the co-authors on the book – Andy Leonard, Tim Mitchell, Jessica Moss, and Michelle … Continued

SSIS Performance Design Patterns

Here are the slides (all 177 of them) for the SSIS Performance Design Patterns talk that I’ve delivered at three different pre-conference events over the past month. Each presentation was slightly different, but the core content remained the same. These events included: SQL Saturday #105 | Dublin SQL Bits X, where I co-presented with John … Continued

Too Many Sources in a Data Flow

Too Many Sources in a Data Flow

This was a recent customer issue that I wanted to share. The customer was transferring a large amount of data between two tables, without performing any transformations on it. They wanted to run multiple transfer streams in parallel, and created a way to split up their source data into six partitions. In their original design, they had … Continued

Design Pattern: Avoiding Transactions

Design Pattern: Avoiding Transactions

SSIS has built-in support for transactions, but their use isn’t ideal for all scenarios. This post covers how SSIS transactions work at a high level, some of the challenges associated with them, and provides some design alternatives. Disclaimer: Many SSIS packages use transactions without issue. Using the built-in functionality is the easiest approach, and (typically) … Continued