I'm trying to import TASKS related to opportunities from one Salesforce org to another using Data Loader.
I have done Excel VLookkups on all Id Values, and all related objects/records are in place on the target org. So, the import CSV includes opportunityId, AccountId, OwnerId from the target org.

I'm getting an error for all records- 'invalid cross reference id'.
I'd like to know which of the related objects does DataLoader use to match records, or what other issue might be behind this error.

Thank you!

  • The CSV should not include the AccountId as SFDC will set that automatically from the Task.WhatId (Opportunity) => AccountId. That is, the Task.AccountId will be the Oppo's AccountId
    – cropredy
    Commented Sep 21, 2020 at 0:15

1 Answer 1


Are your accounts and opportunities already linked before you upload task records? If not, then maybe below applies?



You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .