"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 includes SSIS Design Patterns to:
- migrate SSIS packages through your enterprise without editing connection managers;
- dynamically access externalized SSIS package values;
- extend the functionality of the parent-child pattern to create SSIS execution groups.
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.
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics