Change in data capture - SQL SERVER 2012

Question

Hello all,

I am following this blog and trying to implement CDC.. http://www.mattmasson.com/index.php/2011/12/cdc-in-ssis-for-sql-server-2012-2/

When i create a incremental load setting CDC control operation as Mark processed range... I am getting error and unable proceed further.

Error: [CDC Control Task] Error: "Mark Processed Range operation can be invoked only when the state is ILUPDATE, TFSTART, TFREDO.".

There is no clear view on this one... Can anyone explain how to proceed from here...

Thanks in advance....

Answer 1

Hi Haroon Nazir.S

Welcome to MSDN Forum.

Based on this issue, I suggest you to post the question in SQL Server Forum. There are more related specialists there, I think you can get help more effectively.

Best Regards

---

Allen Li [MSFT]
MSDN Community Support | Feedback to us