Devart Forums

It appears to me that the default setting for Connection Timeout is 60. I increased the setting to 600, and it did not fail this morning, so I guess that did the trick. Thanks!

Amy

I created an SSIS package that runs every 30 minutes daily. This package contains a Devart Salesforce Source object. The first time it runs each day the Devart task consistently fails with the error: "The underlying connection was closed. A connection that was expected to be kept alive was closed by the server". When it runs again 30 minutes later, everything is fine. What do I need to change in the Devart Salesforce Connection Manager settings to prevent the initial failure?

Thank you for your reply. Do I need to purchase SSIS Data Flow Components as an add-on to dotConnect? Or does SSIS Data Flow Components replace dotConnect?

Thanks again,
Amy

According to this web page:
https://www.devart.com/ssis/docs/index. ... nation.htm...
"UseBulkApi" is a setting that is available under "Custom Properties" in the Devart Salesforce Destination object.
However, in my "Advanced Editor for Devart Salesforce Destination" dialog box, UseBulkApi does not appear. I see all the other settings, but not that one. Was this setting moved or removed recently from the latest version of dotConnect for SalesForce?