Scenario
An error occurred while DTS was synchronizing incremental data based on a task that contains incremental data migration or synchronization. The error log information contains "unknown column 'xxx' in field list".
Keywords
unknown column 'xxx' in field list
Possible Causes
DDL synchronization is not selected for the task, but new columns are added to the source database. As a result, the latest DML statement carries the newly added columns.
A DDL synchronization exception occurred.
Solutions
Contact DTS technical support for troubleshooting.