Page 1 of 1

Updating Records VIA SSIS

Posted: Thu 21 Aug 2014 20:16
by yonto
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.

Re: Updating Records VIA SSIS

Posted: Tue 26 Aug 2014 14:53
by Shalex
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).