Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Design Patterns Expand / Collapse
Author
Message
Posted Monday, January 24, 2011 10:47 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:44 PM
Points: 389, Visits: 1,041
"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
Posted Tuesday, January 25, 2011 8:49 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:05 PM
Points: 33,165, Visits: 15,299
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
Posted Monday, October 3, 2011 4:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 7:10 AM
Points: 9, Visits: 293
Hi Andy Leonard,

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

Thank you in advance.
Post #1184416
Posted Monday, October 3, 2011 5:37 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:44 PM
Points: 389, Visits: 1,041
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 »

Add to briefcase

Permissions Expand / Collapse