I am trying to update account records via an SSIS package. I am starting with a data flow task that takes a query to a local database and the Devart Salesforce Source (connected to Accounts) and matches them up based on a customer id column via a merge join.
How do I make sure I am only updating the records included in my original SQL query?
Thanks.
Updating Records VIA SSIS
Re: Updating Records VIA SSIS
You are working with Devart Salesforce Destination component, aren't you? If so, you can check the updated records via output column "Id" (Devart Salesforce Destination > Advanced Editor > Input and Output Properties > RecordId Output > Output Columns > Id).