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

INSERT parent child in DBAmp to salesforce with External Ids

Hi,

I am trying insert order to salesforce and relationship with Order Source and Order PayMent Status Object how I can insert by using External Ids now I selected actual Id and then insert and not use sf_bulkops code is below:

DECLARE @sOrderPaymentStatusId nchar(18)
DECLARE @sOrderSourceId nchar(18)

SET @sOrderPaymentStatusId = (SELECT Id FROM SALESFORCE...Order_Payment_Status__c WHERE Order_Payment_Status__c = @sOrderPaymentStatus)
SET @sOrderSourceId = (SELECT Id FROM SALESFORCE...Order_Source__c WHERE Order_Source_ID__c = convert(varchar(50),@sOrderSource))

INSERT INTO SALESFORCE...Order__c
(Order_No__c, Order_Date__c,Account__c,Contact__c,Order_Source__c,Order_Payment_Status__c)
VALUES(@sOrderNo,@sOrderDate,@sAccountId,@sContactId,@sOrderSourceId,@sOrderPaymentStatusId)
1 person has
this question
+1
Reply