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 ” + ” c.__$operation ” + ” , c.Column1 ” + ” , c.Column2 ” + ” , [...]
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 name> (null, null, ‘all’) Which as I said last post, returns an [...]
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 and I was grateful to have Whitney’s help with understanding [...]