Cross-referencing RecordType table migrating Prod to Sandbox

[Anonymous]

My sandbox has different RecordType ID values for my custom object than in prod, so I created a lookup in the tMap to compare the "DeveloperName" and "SobjectType" fields and return the correct "ID", but Talend is giving me an INVALID_CROSS_REFERENCE_KEY error.

BTW, the table marked "row20" is the RecordType table from the sandbox, so the ID should be valid, FWIW...

I tried to do this via the Upsert mapping but can't add a user key to the RecordType object in SFDC.

Can someone help me understand how to make this work?

[TRF · Accepted solution]

Based on the message in log.txt, it seems thé user profile is not authorized for this recordType.
Check this on salesforce side.

[Anonymous]

@TRF was correct...it took me a while but this link helped...if anyone runs into this issue.

https://dataloader.zendesk.com/hc/en-us/community/posts/209640028-How-do-I-Fix-this-error-SOURCE-Rec...