Two weeks ago I had the pleasure of giving a session on the Belgian SQL Server Days. My session was about SSIS and the new features of Change Data Capture (CDC). With new features I mean the new SSIS 2012 components made by Attunity who simplify the manageability and usability of SSIS packages working with CDC, because technically CDC hasn’t changed since its introduction in SQL Server 2008.

The session went quite well (still waiting on attendee feedback), aside from some microphone problems who forced me to hold a replacement microphone in my left hand – quite difficult to do demos and use Zoomit – and a transaction that got stuck in SSMS and was stubborn enough not to roll back quickly. But these little setbacks didn’t get in the way of the message of the session and they only made myself stronger as a speaker.

The Belgian SQL Server User Group, SQLUG.be, will make all slides available for the attendees, but for those who couldn’t attend the event I decided to put them online anyway. The slides can be downloaded from SlideShare and the demo material can be found here. Basically the demos consist of the following:

  1. Set-up scripts creating some databases and transferring data from AdventureWorksDW2012.
  2. A T-SQL script showing CDC functionality as it was introduced in SQL Server 2008.
  3. A SSIS package for the initial load.
  4. A SSIS package for the incremental load.
  5. A SSIS package for the incremental load but with the addition of the __$reprocessing indicator.

If you have questions about this material, feel free to ask them in the comments.

For more information on SSIS and CDC, check out the resources I listed at the end of the presentation.