通过ssis加载daata时遇到问题 [英] Facing issue while loading daata through ssis
问题描述
大家好，
我正在尝试通过SSIS加载数据 在sql database.i我得到了提到的问题。
来源和目的地 两者都在不同的网络中。
它插入了一些记录，但经过一段时间后面临着如下问题。
[OLE DB Source 6 [1007]]错误：SSIS错误代码DTS_E_OLEDBERROR。 发生OLE DB错误。错误代码：0x80004005。
OLE DB记录可用。 来源："Microsoft SQL Server Native Client 11.0" Hresult：0x80004005 说明："TDS流中的协议错误"。
OLE DB记录可用。 来源："Microsoft SQL Server Native Client 11.0" Hresult：0x80004005 说明："TDS流中的协议错误"。
OLE DB记录可用。 来源："Microsoft SQL Server Native Client 11.0" Hresult：0x80004005 说明："TDS流中的协议错误"。
OLE DB记录可用。 来源："Microsoft SQL Server Native Client 11.0" Hresult：0x80004005 说明："通信链接失败"。
可以使用OLE DB记录。 来源："Microsoft SQL Server Native Client 11.0" Hresult：0x80004005 说明："TCP提供程序：连接尝试失败，因为连接方在一段时间
之后未正确响应，或已建立的连接因连接主机未能响应而失败。
" ;。
[SSIS.Pipeline]错误：SSIS错误代码DTS_E_PRIMEOUTPUTFAILED。 OLE DB Source 6上的PrimeOutput方法返回错误代码0xC0202009。 当管道引擎调用PrimeOutput（）时，组件返回失败代码。失败
代码的含义由组件定义，但错误是致命的，管道停止执行。 在此之前可能会发布错误消息，并提供有关失败的更多信息。
请帮我解决问题。
提前致谢。
问候
Ganesh
通常这种错误是由于网络问题造成的，例如延迟非常高，网络不可用等。看起来您的网络稳定性存在问题。
您需要确保网络稳定。
Hi All,
I am trying to load data through SSIS in to sql database.i am getting bellow mentioned issue .
source and destination both are in different network.
its inserting some records but after some time facing issue like bellow.
[OLE DB Source 6 [1007]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Protocol error in TDS stream".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Protocol error in TDS stream".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Protocol error in TDS stream".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: A connection attempt failed because the connected party did not properly respond after a period
of time, or established connection failed because connected host has failed to respond.
".
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on OLE DB Source 6 returned error code 0xC0202009. 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.
Please help me to resole the issue.
Thanks in advance.
Regards
Ganesh
Usually this error happens due to network issues like latency very high, network unavailable etc. Looks like your network stability has an issue.
You need to make sure network is stable.
这篇关于通过ssis加载daata时遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
