Upsert Salesforce Data using External Id in SSIS

  • 11 March 2024
  • 0 replies
  • 7 views

Userlevel 2
Badge
  1. First, set up the data source. A flat file source is used in this example, but any source will work for this process. 

 

 

 

  1. Drag a Derived Column transformation component from the Data Flow Transformations section of the toolbox onto the data flow. Next, double-click the Derived Column to open the Transformation Editor and add a new column.  

     

     

  1. Set the Derived Column Name to the name of the new column (MyExternalIdColumn in this example). Select the "add as new column" option in the Derived Column field. Set the Expression field to the name of the external Id field in Salesforce for this table, including quotes. This example uses "ExternId__c". 

 

 

 

 

  1. Add the Salesforce destination component. Create a new connection manager and define the connection properties. In addition to specifying your credentials used to log in to Salesforce, set the Pseudo Column to *=*. Setting the Pseudo Column to *=* tells the provider to include the special column External Id in the schema of the table. 

 

 

 

 

  1. In the Mappings section, add a new mapping for the column you created in the step above. In this example, the Input Column is set to MyExternalIdColumn.  

     

     

  1. Select a table and select Upsert in the Action menu. 

 

 

 

 

  1. You can now UPSERT data to Salesforce based on the external Id column. 

 

 

 


This topic has been closed for comments