Updating Records VIA SSIS

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
yonto
Posts: 7
Joined: Thu 21 Aug 2014 20:10

Updating Records VIA SSIS

Post by yonto » Thu 21 Aug 2014 20:16

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Updating Records VIA SSIS

Post by Shalex » Tue 26 Aug 2014 14:53

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).

Post Reply