January 24, 2011 at 10:47 am
"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, Chief Data Engineer, Enterprise Data & Analytics
January 25, 2011 at 8:49 am
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.
October 3, 2011 at 4:59 am
Hi Andy Leonard,
Could you please pass on the link for the presentation you are talking about.
Thank you in advance.
October 3, 2011 at 5:37 am
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, Chief Data Engineer, Enterprise Data & Analytics
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply