When dealing with SQL Azure, SQLBulkCopy connection issues occur.

azure-sql-database sqlbulkcopy

Question

On the brand-new SQL Azure CTP, we are now testing out the SQLBulkCopy API.

We have regularly been able to migrate tables with roughly a million rows, but when dealing with bigger tables, we have connection issues. After random row transfers, we continue to have the following error:

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

I am aware that the connection may be terminated for a variety of reasons, and that it also lists various error codes that are returned, as stated in the SQL Azure connection regulations (specified here). However, I am unable to identify which of these might be the source of the issue or record the error number.

Is there a method to get around this problem and go on with the table row migration?

The SQLBulkCopy choices are as follows:
BatchSize=1000
5000 for BulkCopyTimeout

1
4
4/9/2010 5:36:59 AM

Popular Answer

This error message is listed as one of the symptoms of a Windows 2003 TCP/IP problem in Knowledge Base article 977291.

2
10/27/2010 9:25:20 AM


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow