Salesforce Error Message: The operation has timed out.

Error Message: The operation has timed out.

Action:
When retrieving data using one Salesforce Connection, the package execution succeeds. However if I try to use 3 or more simultaneous Salesforce connections, the following error message is received.

Error Message:
An error occurred with the following error message: "The operation has timed out".

Solution:
The returned error message is misleading. By default the .NET framework is configured to allow maximum of 2 simultaneous connections to the same web site. The default configuration can be modified, by including under the element in your DTExec.exe.config and DtsDebugHost.exe.config files:

1
2
3
4
5
6
7
8
<configuration>
   ...
   <system.net>
      <connectionManagement>
         <add address="*" maxconnection="100"/>
       </connectionManagement>
   </system.net>
</configuration>

The upper configuration will increase the limit to 100 simultaneous connections. Set this limit according to your needs. If you use 64bit system, you have to include the same setting in both "Program Files" and "Program Files (x86)" folders.