I am trying to run the upsert operation in an import package to update data from Salesforce to MS Dynamics.
So I have specified a Target Lookup on the Id based on another unique field, as follows:
When I run the package I get an error saying:
Package failed: The 'accountid' column has DbType 'String', which is different from the target column DbType 'Guid'.
Strange, since the data type I specified is the same field of type GUID.
Run ID: 125592225
Am I missing something? Kindly advise,