Is it possible to delete records in SF using External Id instead of SF Id?
Deletion by external id is not possible. You have to provide the Salesforce ID. Unfortunately it is limitation of the Salesforce API. For more information check these discussions:
Book a Presales Call
Related Articles
Missing objects or columns when using Salesforce Destination Component
Most likely the reason for object or column to be missing is that you are using older version of Salesforce API. To verify which version of Salesforce API you are using please check what is showing in the Server URL field on the Salesforce Connection ...Error Message: Invalid Server Host (Salesforce Connection)
Action: When using the Salesforce Connection I am getting the error message below: Error Message: "Invalid Server Host" Solution: Salesforce has sent out notices to their customers that some Salesforce Platform API legacy versions will be deprecated ...How can I retrieve updated and deleted Salesforce records?
You can use the following reusable script with the JavaScript component to retrieve records that were deleted from Salesforce between specified dates: https://www.cozyroc.com/ssis/script-salesforce-get-deleted-source To retrieve records that have ...Why am I unable to see a lookup field that is newly added in Salesforce?
Scenario: The Salesforce Admin created some new fields in an object, but a lookup field is still not showing in the Salesforce Source or Destination component. Solution: It may be that your Salesforce Admin created the field but did not properly set ...Salesforce Destination: How to modify a Salesforce Destination object dynamically at runtime
The destination object is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired name of the destination object. Right-click on data flow canvas and select ...