Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m frustrated

sf_bulkops 'UPSERT:BulkAPI' Fails

When I execute":


sf_bulkops 'UPSERT:BulkAPI','SFDBLNKINT_STG', 'User_Load', 'SP_User_ID__c'

I get:

09:35:04: Run the DBAmp.exe program.

09:35:04: DBAmp Bulk Operations. V2.12.16 (c) Copyright 2006-2010 LLC

09:35:04: Upserting Salesforce using User_Load (CRPSDB01D\DEV / SFDBINT) .

09:35:06: Error: Unable to create job.

09:35:06: Error: InvalidJob. External ID was blank for User. An External ID must be specified for upsert.

09:35:07: Error: DBAmp.exe was unsuccessful.

09:35:07: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe upsert:bulkapi User_Load "CRPSDB01D\DEV" "SFDBINT" "SFDBLNKINT_STG" "SP_User_ID__c"

--- Ending SF_BulkOps. Operation FAILED.

Msg 50000, Level 16, State 1, Procedure SF_BulkOps, Line 93

--- Ending SF_BulkOps. Operation FAILED.

If I omit the "BulkAPI" the process works.

Any idea on how to overcome this?
1 person has
this question