Unable to connect to the remote server message

[Tim Huemmer]

I have been using CozyRoc's CRM components at several different
customer sites. I frequently run into this message when running SSIS
packages that are inserting/updating data in MSCRM:

Error: An error occurred with the following error message: "Unable to
connect to the remote server".

If you simply re-run the package, it will run fine (at least for a
couple thousand records or so). These errors seem to be random, and
tend to happen after several thousand records have been successfully
processed.

I have tried the following steps to fix the error to no avail:
- Increase the ServerTimeout on the CRM connection
- Run fiddler and look for a more detailed message (none exist, it
just simply stops sending requests)

I would think that this could point to a network type issue, however I
have seen it happen at 3 different customer locations that I have
worked with.

What additional steps can be tried to troubleshoot this or obtain a
more detailed level of diagnostic information?

Thanks in advance for any assistance you can provide

[Tim Huemmer]

In case someone else is running across this issue, here is the
solution that worked for me (Thanks, Ivan for providing the
assistance!!)

Change the ConnectionSharing property on the CRM connection from false
to true. This prevents socket connection exhaustion scenarios from
occuring.

[Mark Underhill]

Excellent - thanks, this worked for me too.