Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Bradley Schacht

Bradley Schacht is a Data Platform Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Admin". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as and an active member of the Jacksonville SQL Server User Group (JSSUG).

Presentation Update: Change Data Capture (CDC) Made Easy With SSIS 2012


Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data capture and how to consume it with SSIS. CDC is one of the features I wish more of my clients were leveraging. It makes doing incremental loads dramatically more simplified. In this session I’ll show you quickly how to enable CDC then how to use SSIS to consume the data. Check out the details and a link to register below. Oh, did I mention it’s free?? Be sure to register even if you aren’t able to attend so you can get a link to the recording and watch it later.

Registration Link:

Title: Change Data Capture (CDC) Made Easy With SSIS 2012
Date: January 28, 2014
Description: One of the hidden gems introduced in SQL Server 2008 was change data capture. Loading your data warehouse has never been easier thanks to new components in SSIS 2012 designed specifically to consume CDC data. This amazing feature automates the process of detecting inserts, updates and deletes in your data; a vital step in determining type 1 and type 2 record updates. This session will begin by discussing the setup and configuration of CDC. Next Brad will jump into SQL Server Data Tools and walk you step by step through creating an SSIS package to load a dimension that will leverage all the new tasks and components. After this session you will have a very powerful tool in your SSIS tool belt.




Leave a comment on the original post [, opens in a new window]

Loading comments...