August's Presentation: SSIS FrameWorks!
Here is the slide show for this event:Object Oriented Technics applied to SSIS Development.zip; Code samples to follow soon (check back in a day or two)
This Months Sponsor-McClain Group II
Abstract:
SSIS Frameworks focuses on Object Oriented programming techniques applied to SSIS Development. We will explore the concepts of encapsulation and modularity from an Object Oriented Programming perspective and how this can be applied to developing SSIS packages. SSIS Frameworks will look into building both a metadata structure and the SSIS package design, to support breaking units of work into small reusable SSIS packages and how to structure those packages for re-use. Real world examples from a Data Warehouse to Master Data Management Systems will be referenced to show how this type of SSIS development can cut development time and allow for coding work to be spread across a team. We will also get into the nitty gritty of some SSIS configurations/event handlers/variable passing.
About Steve:
Steve Fibich currently works in Richmond VA at PFGC as the Systems Architect on a Master Data Management project utilizing SQL Server 2005 and SSIS 2005 pulling data from iSeries, Unix, VAX, and SAP for a massive system integration effort. He has been working with SQL Server since 6.5 building Data Warehouses, building integration systems for third party product integration, creating Master Data Management systems , and doing general DBA work for the past 10 years.