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.

Update November 10, 2015

Here is a link to the files I mentioned in my webinar if you would like to download them and run through the demos on your own computer:

Bradley Schacht

Bradley Schacht is a Cloud 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 Administration". 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).

You may also like...

6 Responses

  1. Amos says:

    Thanks Bradley for your webinar, are you able to post the sql scripts shown in the webinar?

  2. Ron Holmes says:

    I am enjoying your CDC webinar, could you please let me know where the SQL Scripts had in this webinar, the others look interesting also.

  3. I just watched this webinar and you had indicated the SQL scripts would be posted to your blog, can you tell me location?

  4. Bonnie says:

    Thank you!

  5. says:

    Hi Bradley, Great webinars SSIS CDC and SSIS Load patterns ! learned a lot. Please keep doing more about DW and ETL. The link for sql script is not working, there is other location ?Thank you

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.