Reset a relational target table in a replication task to drop all of the target tables in the task.
You might need to reset a relational target for the following reasons:
•If the data type, precision, or scale of a Salesforce source field changed and you run the replication task as an incremental load, the task might fail. This is because of a mismatch between the data types of the source field and the column of the relational target table. The task might also fail because the target table column might not be able to store all values from the Salesforce field. You can reset the target table to synchronize the data type, precision, or scale of the target table column with the Salesforce field. If the precision or scale decreases, the replication task succeeds and the target table columns remain unchanged.
•You delete a field in a Salesforce source and the replication task writes to a Microsoft SQL Server relational target.
If you run a replication task that writes to a Microsoft SQL Server target and the source is missing a field or column, the replication task fails. To run the replication task successfully, reset the target table to re-create the target based on the latest source definition, and then run the replication task.