SQLBulkCopy connection errors when working with SQL Azure

Question

We are currently testing the SQLBulkCopy API on the new Azure CTP SQL.

Although we were able to wrap tables with approximately one million rows sequentially, we encounter join errors when working with large tables. We continue to receive (after accidentally passing strings) the following error:

There was a transport layer error while receiving results from the server. (provider: TCP provider, error: 0 - An existing connection was forcibly closed by the remote host.)

I understand that the Azure SQL Connection Policies (mentioned here ) indicate that the connection may be disconnected for several reasons, and also mentions some error codes that are returned. But I can’t figure out which one can cause an error or get an error code.

Is there a way to overcome this error and continue the migration of the table rows?

Used SQLBulkCopy parameters:
BATCHSIZE = 1000
BulkCopyTimeout = 5000

Answer 1

Knowledge Base 977291 gives this error message as a symptom of a TCP / IP problem in Windows 2003.