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 Source [83]] Error: "No CDC End (CE) in state variable User::CDC_State. The state variable value is ILEND/IR/0x000000370000016F0002/0x00000038000001BF0002/TS/2012-04-12T08:55:47.3559125/.". 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....Haroon Nazir.S

Hi Haroon Nazir.S, According to the error message, it might be due to the following issues: 1. It fails to read the persistent CDC state or when updating the persistent state fails. 2. It fails to read the current LSN information from the source database. 3. The CDC state read is not consistent. In all of these cases, the CDC Control task reports an error that can be handled in the standard way SSIS handles control-flow errors. For more information about CDC Flow Components, please refer to: http://msdn.microsoft.com/en-us/library/hh231087.aspx And how to handle control-flow errors, please refer to: http://technet.microsoft.com/en-us/library/cc304419.aspx Thanks, Eileen

Hi, I am the same Error: [CDC Source [83]] Error: "No CDC End (CE) in state variable User::CDC_State. in the table CT, i found. [__$end_lsn] field is null and thinking this is problem. __$start_lsn __$end_lsn __$seqval __$operation __$update_mask PrimerNombre 0x00000DF700006BF1001B NULL 0x00000DF700006BF10003 3 0x0002 GLADYS is the possible this conclusion, Thanks. Elicx Villaseca

This probably arises because you are managing your CDC Control Flow tasks and table updates in the wrong sequence. The order has to be: 1) Make changes to CDC enabled table as required 2) CDC Control Task: Get Processing Range 3) Process CDC changes in Data Flow using CDC Source / Splitter 4) CDC Control Task: Mark Processed Range I initially hit this error when I was running tasks in the order 2,1,4,3 (general confusion about how to implement this properly) Cheers, JamesJames Beresford @ www.bimonkey.com & @BI_Monkey SSIS / MSBI Consultant in Sydney, Australia SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex