unable to obtain exclusive access to this record - error

[twong]

My SSIS package is doing an update on records within Salesforce. It's using a "Devart Salesforce Destination" control. I believe the common issue for this error (not specific to this control) is multiple threads trying to update things at the same time. However, there is no setting for controlling a thread count. Any thoughts?

[Shalex]

I believe the common issue for this error (not specific to this control) is multiple threads trying to update things at the same time.

The reasons of the error are described at https://salesforce.stackexchange.com/qu ... his-record.

However, there is no setting for controlling a thread count. Any thoughts?

Please right click Devart Salesforce Destination > Show Advanced Editor > Component Properties and try setting ParallelBatchProcessing=False.

[twong]

I tried adding the property. Still no luck :(

[Shalex]

1. Is it possible that other package or other dataflow (or someone via web interface) works with the same Salesforce object in the same time?

2. Does the Salesforce object you update have any triggers?

3. Try disabling Bulk API by setting Bulk API=False in all Devart Salesforce Destination components that work with the Salesforce object you get "unable to obtain exclusive access to this record" with.