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?
Question about Salesforce Destination node
-
- Posts: 1
- Joined: Thu 18 Jul 2019 15:32
Re: Question about Salesforce Destination node
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
* 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