I need to migrate 5GB of attachments to Salesforce.
I've created the mapping file and have been able to successfully upload some files using Data Loader (Lexi Loader).
I'm currently running into the following intermittent issues:
- Data loader fails with the error "failed to create batch"
- Data loader hangs at 999 entries
- Data loader will only work if batch size is set to 1
I've looked at using DataLoader.io, but my some of my attachments are up to 100MB and DataLoader.io seems to have a 5MB limit.
It seems like I must be missing something obvious because I know people migrate large CRM datasets to Salesforce.com every day.
What's a reliable way to import thousands of attachments to Salesforce?