For a source field, do not edit the metadata for an id column from

string

to

int

.

When the source has a field of the binary data type, the mapping fails with the following error:

When you create conditions for router groups and connect the router groups to target tables, and one of the condition fails, the mapping does not process the rest of the conditions as well. The mapping runs without

SQL ELT optimization

.