CDC SSIS 2012 CDC Source Error RRS feed

  • Question

  • Hi

    I tried to play with CDC in SSIS 2012 ,I turned on the CDC on my database and on my table CDC task ran good when it came to CDC source I got this following Error

    [CDC Source [2]] Error: "No CDC End (CE) in state variable User::CDC_State. The state variable value is ILSTART/IR/0x00070A5D000000850002//TS/2012-05-23T22:16:31.6680000/.".

    [CDC Source [2]] Error: System.Exception: No CDC End (CE) in state variable User::CDC_State. The state variable value is ILSTART/IR/0x00070A5D000000850002//TS/2012-05-23T22:16:31.6680000/.
       at Attunity.SqlServer.CDCSrc.CdcSourceComponent.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
       at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)

    [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on CDC Source returned error code 0x80131500.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.

    Did any one tried it and can any one solve thsi error


    Thursday, May 24, 2012 9:43 AM


All replies