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:
5000 for BulkCopyTimeout