XXXXX: When I use SqlBukiCopy, the following error is reported as soon as the data volume reaches 1000000.
Exception details: System. Data. SqlClient. SqlException: the timeout has reached. The timeout has expired or the server has not responded before the operation is completed.
The timeout has reached. The timeout has expired or the server has not responded before the operation is completed.
Isn't it my cup... So what can be judged by the maximum data volume .. The master did not dare to do it, but there are still some solutions. Microsoft has provided a solution. You only need to download the corresponding patch from the following table and install it on the server.
For x86-based computers
Http://download.microsoft.com/download/2/C/5/2C5BCDC9-3241-443A-9F96-4E0B0EDFA727/NDP20-KB916002-X86.exe
For x64-based computersHttp://download.microsoft.com/download/D/3/9/D39C79DF-4158-45DF-9031-92C52AB0ED19/NDP20-KB916002-X64.exe For Itanium-based computersHttp://download.microsoft.com/download/0/0/3/00392DD3-5B4F-4D99-94E8-6827B8F8D7EF/NDP20-KB916002-IA64.exe