Magenic Technologies Community Blog

Browse by Tags

• 2008
• CDC

• SSIS CDC LSN Debugging nightmare second problem

  Continuing the CDC debugging posts: Intro First Problem Now that I have the StartLSN and EndLSN I was ready to go. Hit my breakpoint and the variables were set appropriately. Woo-hoo! Then…wait a minute…what? vSQLQuery.Value = "SELECT " Read More... Posted Friday, December 18, 2009 9:00 AM from AaronLowe.net | 0 Comments Filed under: 2008, SSIS, CDC

• SSIS CDC LSN Debugging nightmare first problem

  So now that we have the idea let’s look as the four main problems I encountered: The first problem I noticed was that the SQL query that was running still had nulls in on the StartLSN and EndLSN so I was querying: cdc.fn_cdc_get_net_changes_<instance Read More... Posted Thursday, December 17, 2009 7:00 AM from AaronLowe.net | 0 Comments Filed under: 2008, SSIS, CDC

• SSIS CDC LSN Debugging nightmare introduction

  The other day I was working on an SSIS implementation that was utilizing Change Data Capture (CDC) to identify the source data that needed to be transformed into the destination.  This is the first time that I had used CDC other than a quick demo Read More... Posted Wednesday, December 16, 2009 7:00 AM from AaronLowe.net | 0 Comments Filed under: 2008, SSIS, CDC

• SSIS Blog Post Thank you

  Traditionally I have used SSIS for OLTP data movements, however lately I’ve been loading a Data Warehouse which has slightly different requirements.  I just wanted to drop a quick note to highlight the great resources that already exist out there Read More... Posted Monday, January 26, 2009 8:29 PM from AaronLowe.net | 0 Comments Filed under: SSIS