Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Field does not match an External ID

Command: EXEC SALESFORCE.dbo.SF_BulkOps 'Upsert:BulkAPI','SFDB_HPLAPPERT','Department__c_Migrate','OldId'

Error: InvalidJob. Field name provided, OldId does not match an External ID for Department__c

1.) I have defined the OldId field on the Custom Object Department__c in Salesforce as a Text 18. In the SQL table that I am trying to Upsert from it is defined as nvarchar(18).

2.) I can query the Department__c table via DBAmp SQL and I can see the OldId field.

3.) My DBAmp version is V2.13.13

1 person has
this question