DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)

Error string:  Error at Destination for Row number 75584. Errors encountered so far in this task: 1.Error source:  DTS Data Pump

 Help file: 

Help context:  0

Error Detail Records:

Error:  -2147467259 (80004005); Provider Error:  11 (B)

Error string:  [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

Error source:  Microsoft OLE DB Provider for SQL Server

Help file: 

Help context:  0

DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error = -2147213206 (8004206A)

Error string:  The number of failing rows exceeds the maximum specified.

Error source:  Microsoft Data Transformation Services (DTS) Data Pump

Help file:  sqldts80.hlp

Help context:  0

Error Detail Records:

Error:  -2147213206 (8004206A); Provider Error:  0 (0)

Error string:  The number of failing rows exceeds the maximum specified.

Error source:  Microsoft Data Transformation Services (DTS) Data Pump

Help file:  sqldts80.hlp

 Help context:  0

Error:  -2147467259 (80004005); Provider Error:  11 (B)

Error string:  [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

Error source:  Microsoft OLE DB Provider for SQL Server

Help file: 

Help context:  0

DTSRun OnFinish:  DTSStep_DTSDataPumpTask_1

DTSRun:  Package execution complete.

2、反复检查数据库日志文件和操作系统日志文件，发现如下设置：

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4

2009-02-28 16:47:39.79 server    SQL Server is starting at priority class 'high'(2 CPUs detected).

2009-02-28 16:47:41.32 server    Working Set size set to 773120 kilobytes.

初步判断是由于这两个参数设置引起的错误。

3、修正参数，命令如下：

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4   sp_configure 'set working set size', 0  

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4   sp_configure 'min server memory (MB)', 0 

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 sp_configure 'priority boost', 0

重新启动服务器后，问题得到解决