CBusPASS Meeting – July 9th, 2009

In two weeks, Andy Leonard will be presenting remotely for CBusPASS, the friendly Columbus PASS chapter.

Come pay us a visit. It will be a good time.

Here is the information from the CBusPASS website:

Topic
Incremental Loads, Change Data Capture, and SSIS 2008

Abstract
Change Data Capture is a new SQL Server 2008 feature. One benefit of CDC is data filtering for Incremental ETL in SSIS: only touching rows that are new, updated, or have been deleted! In this presentation I walk through enabling Change Data Capture in SQL Server 2008, then present an overview of an SSIS package that utilizes Change Data Capture to perform Incremental ETL.

Presenter

Andy Leonard is an Architect and manager with Unisys Corporation, SQL Server Database and Integration Services developer, SQL Server MVP, PASS Regional Mentor (Southeast US), and engineer. He is a co-author of Professional SQL Server 2005 Integration Services (Programmer to Programmer), Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers (Programmer to Programmer), and MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits). Andy founded and manages VSTeamSystemCentral.com and maintains two blogs there: Applied Team System and Applied Business Intelligence . He also blogs for SQLBlog.com . Andy’s background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005, and 2008; and test-driven database development.