如何解决 DTS_E_OLEDBERROR.在 ssis

2021-12-30 00:00:00 sql-server ado.net ssis oledb

在一个由数据流任务组成的ssis包中,包含OLEDB 源和 OLDB 目标 ..provider 是 sql 本机客户端..这曾经运行良好..但现在出现如下所示的错误..

In an ssis package consists of data flow task,contains OLEDB source and OLDB Target ..provider is sql native client..This used to run fine ..but now got an error as shown below..

请告诉我如何解决它?将其更改为ado.net?

Please tell me how to resolve it ?changing it to ado.net?

操作系统:windows 7 专业版,数据库为 SQL Server 2000

OS :windows 7 professional and the DB is SQL Server 2000

我急需帮助解决 SSIS 的问题.我正在尝试使用 SSIS 将数据从一个 SQL 集群导出/导入到另一个.两者都是 SQL 2008 Ent.64 位.两者都在 Win2k8 Ent 上运行.64 位.目标是Win2k8 R2.

I am in much needed help resolving a problem with SSIS. I am trying to export/import data using SSIS from one SQL Cluster to another. Both are SQL 2008 Ent. 64bit. Both are running on Win2k8 Ent. 64bit. The destination is Win2k8 R2.

我遇到的问题是间歇性的,但非常频繁.SSIS 连接在各个步骤断开.有时在第一个任务上失败,有时在最后一个任务上失败......有时它完全完成了第一次迭代(在 for-each 循环中)并在接下来的迭代中失败.

The problem I experience is intermittent but very frequent. The SSIS connection drops at various steps. Sometimes failing on the first task, sometimes on the last.. sometimes it completes the first iteration completely (in for-each loop) and fails on following iteration.

此软件包的相同版本过去曾在不同的目标上运行,没有出现故障.之前的目标是在 Win2k3 Standard 和 SQL 2005 Std 上运行的单个服务器(非集群).64 位.

An identical version of this package was running against a different destination in the past without failures. The previous destination was a single server (non-clustered) running on Win2k3 Standard, and SQL 2005 Std. 64 bit.

新的目标服务器完全没有流量.有足够的 CPU/内存等.包已经从源服务器或目标服务器执行,结果相似.

The new destination server is completely free of traffic. Has plenty of CPU/Memory, etc.. The package has been executed from either the Source server or the Destination server with similar results.

正在复制到 [dbo].[AGGSLIVE_Bandwidth](错误)留言错误 0xc0202009:数据流任务 1:SSIS 错误代码 DTS_E_OLEDBERROR.发生 OLE DB 错误.错误代码:0x80004005.OLE DB 记录可用.来源:Microsoft SQL Server Native Client 10.0"
Hresult:0x80004005 说明:通信链接失败".OLE DB 记录可用.来源:Microsoft SQL Server Native Client 10.0"
Hresult:0x80004005 说明:TCP 提供程序:远程主机强行关闭了现有连接.".(SQL Server 导入导出向导)

Copying to [dbo].[AGGSLIVE_Bandwidth] (Error) Messages Error 0xc0202009: Data Flow Task 1: 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 10.0"
Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0"
Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". (SQL Server Import and Export Wizard)

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

Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (62)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (62)" 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)

错误 0xc0047022: 数据流任务 1:SSIS 错误代码 DTS_E_PROCESSINPUTFAILED.组件Destination - AGGSLIVE_Bandwidth"上的 ProcessInput 方法(49) 处理输入目标输入"时失败,错误代码为 0xC0209029(62).标识的组件从 ProcessInput 方法返回了一个错误.该错误是特定于组件的,但该错误是致命的,会导致数据流任务停止运行.在此之前可能会发布错误消息,其中包含有关失败的更多信息.(SQL Server 导入导出向导)

Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - AGGSLIVE_Bandwidth" (49) failed with error code 0xC0209029 while processing input "Destination Input" (62). 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)

错误 0xc0209017: 数据流任务 1:设置缓冲区的行集结束失败,错误代码为 0xC0047020.(SQL Server 导入导出向导)

Error 0xc0209017: Data Flow Task 1: Setting the end of rowset for the buffer failed with error code 0xC0047020. (SQL Server Import and Export Wizard)

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

Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - Query" (1) returned error code 0xC0209017. 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)

推荐答案

我遇到了同样的问题,它似乎与对并发任务使用相同的数据库连接有关.可能有一些替代解决方案(也许更好),但我通过将 MaxConcurrentExecutables 设置为 1 来解决它.

I had this same problem and it seemed to be related to using the same database connection for concurrent tasks. There might be some alternative solutions (maybe better), but I solved it by setting MaxConcurrentExecutables to 1.

相关文章