链接服务器:远程主机强行关闭了现有连接. [英] Linked Server: An existing connection was forcibly closed by the remote host.

问题描述

我需要有关链接服务器的帮助.

我们的两台服务器有两个不同的位置，我想每天将数据从一台服务器传输到另一台服务器.为此，我使用了链接服务器.

两者都是SQL Server 2005和操作服务器2008.

如果我传输数据，说大约有10000条记录就可以了.

但是，当我尝试发送多于10000行时，则在30到40分钟后出现一些错误.

以下是错误消息.



-正在复制到[XXXXXXXXXXXx].[dbo].[XXXXXXXXXXXXXXXXx](错误)

消息

·错误0xc0202009:数据流任务:SSIS错误代码DTS_E_OLEDBERROR.发生OLE DB错误.错误代码:0x80004005.
OLE DB记录可用.来源:"Microsoft SQL本机客户端"结果:0x80004005说明:通信链接失败".
OLE DB记录可用.来源:"Microsoft SQL Native Client"结果:0x80004005说明:"TCP Provider:远程主机强行关闭了现有连接.
.
(SQL Server导入和导出向导)


·错误0xc0209029:数据流任务:SSIS错误代码DTS_E_INDUCEDTRANSFORMFAILUREONERROR. 输入目标输入"(107)"失败，因为发生了错误代码0xC020907B，并且在输入目标输入"(107)"上的错误行配置指定发生错误.指定组件的指定对象发生错误.在此之前可能会发布错误消息，其中包含有关失败的更多信息.
(SQL Server导入和导出向导)


·错误0xc0047022:数据流任务:SSIS错误代码DTS_E_PROCESSINPUTFAILED.组件目标-XXXXXXXXXXXXX"(94)上的ProcessInput方法失败，错误代码为0xC0209029.所标识的组件从ProcessInput方法返回了错误.该错误是特定于组件的，但该错误是致命的，将导致数据流"任务停止运行.在此之前可能会发布错误消息，其中包含有关失败的更多信息.
(SQL Server导入和导出向导)


·错误0xc0047021:数据流任务:SSIS错误代码DTS_E_THREADFAILED.线程"WorkThread0"已退出，错误代码为0xC0209029.在此之前可能会发布错误消息，并提供有关线程退出原因的更多信息.
(SQL Server导入和导出向导)


·错误0xc02020c4:数据流任务:尝试将行添加到数据流任务缓冲区失败，错误代码为0xC0047020.
(SQL Server导入和导出向导)


·错误0xc0047038:数据流任务:SSIS错误代码DTS_E_PRIMEOUTPUTFAILED.组件源-XXXXXXXXXXXX"(1)上的PrimeOutput方法返回了错误代码0xC02020C4.当管道引擎调用PrimeOutput()时，该组件返回了失败代码.故障代码的含义由组件定义，但错误是致命的，并且管道停止执行.在此之前可能会发布错误消息，其中包含有关失败的更多信息.
(SQL Server导入和导出向导)


·错误0xc0047021:数据流任务:SSIS错误代码DTS_E_THREADFAILED.线程"SourceThread0"已退出，错误代码为0xC0047038.在此之前可能会发布错误消息，并提供有关线程退出原因的更多信息.
(SQL Server导入和导出向导)




请帮助我找到解决方案.

谢谢

Jigar Malik

Hi,
I need help regarding Linked server.

We have two different locations for our two servers and I want to transfer my data from one server to another server every day. For that I used linked server.

Both are SQL Server 2005 and operating server 2008.

If I transfer data say about 10000 records it works fine.

But when I am trying to send more then 10000 rows then I am getting some error after 30 to 40 min.

Below is the error massage.



- Copying to [XXXXXXXXXXXx].[dbo].[XXXXXXXXXXXXXXXXx] (Error)

Messages

· Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
".
(SQL Server Import and Export Wizard)


· Error 0xc0209029: Data Flow Task: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (107)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (107)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)


· Error 0xc0047022: Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - XXXXXXXXXXXXX" (94) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)


· Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited.
(SQL Server Import and Export Wizard)


· Error 0xc02020c4: Data Flow Task: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
(SQL Server Import and Export Wizard)


· Error 0xc0047038: Data Flow Task: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - XXXXXXXXXXXX" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)


· Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.
(SQL Server Import and Export Wizard)




Please help me to find some solution.

Thanks

Jigar Malik

推荐答案

我不确定这是否对您有帮助，但是我发现

I''m not sure if this will help you for sure, but I found this.

这篇关于链接服务器:远程主机强行关闭了现有连接.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！