THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

PASS Summit 2009 - Applied SSIS Design Patterns

A couple weeks ago, I learned my proposal for a spotlight session entitled "Applied SSIS Design Patterns" had been accpeted by the PASS Summit 2009 speaker selection committe. Cool! I've never done a PASS Summit spotlight session.

The abstract for the presentation follows:

Applied SSIS Design Patterns

"Design Patterns" is more than a trendy buzz phrase; design patterns are a way of breaking down complex development projects into manageable tasks. They lend themselves to several development methodologies and apply to SSIS development. Chances are you're using your own design patterns now! In this spotlight session, Andy Leonard defines design patterns applicable to SSIS, and then demonstrates their use to develop SSIS solutions. The session is designed for those with little or no exposure to design patterns or application development methodologies; but with good experience in SSIS. The goal is to introduce the science, terminology, and philosophy of design patterns to those wishing to learn more; then demonstrate how to leverage the principles just described by applying them to every day SSIS development. Demonstrations will also include migration through the application lifecycle, deployment, and maintenance.

There are lots of other cool spotlight sessions. Check them out here, and I hope to see you at the PASS Summit 2009!

:{> Andy


Published Wednesday, June 17, 2009 8:00 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Barry said:

Hi Andy,

Are the slides/ handouts for this spotlight session available to download anywhere?  I would be interested in reading about the topic further.


February 2, 2010 4:43 PM

andyleonard said:

Hi Barry,

  Even better - you can get the session in its entirety by ordering the PASS DVDs (

:{> Andy

February 2, 2010 4:51 PM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement