0

I am trying to implement change data capture in SQL Server 2012. I enabled it at database and table level. when i try to update the table, CDC_CT captures the changes. However when i am using SSIS CDC components, it doesnt pick anything.

the version of SQL server is: Microsoft SQL Server 2012 (SP3-CU10-GDR) (KB4057121) - 11.0.6615.2 (X64) Jan 9 2018 21:26:48 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor)

Can someone please guide?

CDC_Initial_Load

CDC_Mark_Changes

CDC_Data_Flow

user2438237
  • 315
  • 2
  • 4
  • 16
  • This is too broad to troubleshoot with the information supplied. We can't see your SSIS package, your CDC configurations, and would be guessing. This is also more DBA related, which is better suited for dba.stackexchange.com IMHO. – S3S Aug 22 '18 at 13:23
  • @scsimon : Thanks. I have Added the pictures to provide more information. – user2438237 Aug 22 '18 at 17:03
  • @scsimon : i asked this question there too. – user2438237 Aug 22 '18 at 17:10
  • Need more information on the error you are facing, But here are the basics step that i would suggest.1) cdc.dbo__CT table if it has captured the changes 2) can you able to run the intial load without any problem 3)check for the CDC_STATE value 4) Run the incremental load and check if the CDC_STATE table is marking the watermark correctly. – Siva Oct 01 '18 at 22:31

1 Answers1

0

There are some issues with SP3 in sql server 2012. As soon as I installed SP4 this issue went away.

user2438237
  • 315
  • 2
  • 4
  • 16