Page 1 of 1

Question about Salesforce Destination node

Posted: 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?

Re: Question about Salesforce Destination node

Posted: Mon 22 Jul 2019 14:00
by Shalex
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