SSIS Design Patterns

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Career » Presentations and Speaking » SSIS Design Patterns

SSIS Design Patterns

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Leonard

Posted Monday, January 24, 2011 10:47 AM

Old Hand

Group: General Forum Members
Last Login: Monday, June 10, 2013 12:27 PM
Points: 375, Visits: 950

"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! At the PASS Summit 2009, Andy Leonard demonstrated ways to use some less-documented features of SSIS. At the PASS Summit 2010 Andy shares more SSIS Design Patterns.

This session is for experienced SSIS developers. Attend and learn the Parent-Child SSIS design pattern, how to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable values between parent and child packages (in both directions).

Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard

Post #1052561

Steve Jones - SSC Editor

Posted Tuesday, January 25, 2011 8:49 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:19 PM
Points: 31,526, Visits: 13,863

I like it. Not sure the 2009 or 2010 references are needed if you use this outside of the Summit, but it's a good overview with a few examples.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1053238

Ravi Kumar V

Posted Monday, October 03, 2011 4:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 07, 2013 3:47 AM
Points: 9, Visits: 232

Hi Andy Leonard,

Could you please pass on the link for the presentation you are talking about.

Thank you in advance.

Post #1184416

Andy Leonard

Posted Monday, October 03, 2011 5:37 AM

Old Hand

Group: General Forum Members
Last Login: Monday, June 10, 2013 12:27 PM
Points: 375, Visits: 950

Hi Ravi,

I'm traveling today and find it difficult to type or paste links from my phone. I'm old school. And old. If you browse to SQLblog.com and cluck on my blog, you can search for a post called Designing an SSIS Framework. There's a link in that post to a version of an SSIS Framework that demonstrates a serial execution pattern and centralized logging.

Hope this helps,
Andy

Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard

Post #1184440

« Prev Topic | Next Topic »

Permissions