Forum Discussion

joel_delima's avatar
joel_delima
Regular Visitor
5 days ago

Fabric Copy Job CDC Error On Incremental Load

I'm using the fabric copy job to incrementally copy data from a CDC enabled table on SQL Server 2008 R2. The initial full load ran successfully, however all subsequent runs are failing and returning ...
data engineering
v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity Support
20 hours ago

Hi joel_delima​ 

We would like to inquire whether have you got the chance to check the solutions provided by other users in community to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

joel_delima's avatar
joel_delima
Regular Visitor
20 hours ago

Thank you, we've confirmed that this error is due to database compatibility level 80 on sql server 2008 R2. Fabric CDC Copy Job runs fine on compatibility levels above 80.