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
ASK INFAPreview
