This post shows one of the possibilities to resolve the error “SSIS CDC state User::CDC_State is not well structured”.
This full error as below. This happen in your CDC Source normally.
I[Shipper CDC Records ] Error: System.Exception: Value ILUPDATE/CE/0x00000031000001D80001/IR/Ox00000031000001650002//TS/2018-03-15T11:40:15.3532021/ of CDC state User::CDC_State is not well structured. Structure must be – logicalName(required)/[CS//] (optional)[CE/cce-lsn>/](optional)[IRcir-start>/cir-end>/](optional)/[TS/timestamp/](optional) [ER/cerror-message>/](optional). at Attunity.SqlServer.CDCSrc.CdcSourceComponent.PrimeOutput(Int32 outputs, Int32 outputlDs, PipelineBuffer buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput (IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32 outputlDs, IDTSBuffer100 buffers, IntPtr ppBufferWirePacket)
If you go to check your CDC_State table you likely to see the state started with.
You need your CDC state start with
Most likely you do not have a CDC Control Task set CDC control operation to Mark initial load end .