Question about Salesforce Destination node

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
maxr@expeditions.com
Posts: 1
Joined: Thu 18 Jul 2019 15:32

Question about Salesforce Destination node

Post by maxr@expeditions.com » Thu 18 Jul 2019 20:41

When I create a data flow with Salesforce Destination it automatically creates an output on that node called RecordId that outputs Salesforce ID of the created object as well as all input columns.

I rarely use RecordId in subsequent nodes so SSIS gives me a warning about unused column.

If I go to Advanced Editor and delete column Id from RecordId output then NO rows are being sent to that output at all.

How can I fix that?

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

Re: Question about Salesforce Destination node

Post by Shalex » Mon 22 Jul 2019 14:00

This looks like a designed behavior:
* if all output columns are deleted, there would be no rows in the output
* if you process the output, describe the problem with your approach caused by the warning

Post Reply