如何解决DTS_E_OLEDBERROR。在SSIS [英] how to resolve DTS_E_OLEDBERROR. in ssis

问题描述

在SSIS包由数据流任务，包含 OLEDB源和OLDB目标..provider是用来运行得很好..但SQL本机client..This现在得到了一个错误，如下图所示。

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

[Axe_Data [737]错误：SSIS错误code DTS_E_OLEDBERROR。出现了一个OLE DB错误。错误code：0x80004005的。 一个OLE DB记录。来源：Microsoft SQL Server本机客户端10.0HRESULT：0x80004005说明：通信链路故障。 一个OLE DB记录。来源：Microsoft SQL Server本机客户端10.0HRESULT：0x80004005说明：TCP提供程序：信号灯超时时间已过期

[Axe_Data [737]] 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 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: The semaphore timeout period has expired.

我在急需帮助解决与SSIS的一个问题。我想从一个SQL群集导出使用SSIS /导入数据到另一个。两者都是SQL 2008 ENT。 64。两者都在Win2k8耳鼻喉科运行。 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.

这个包的相同版本运行针对以往不同的目标没有故障。在previous目的地是单个服务器（非群集）上WIN2K3标准运行，和SQL 2005标准。 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错误code DTS_E_OLEDBERROR。出现了一个OLE DB错误。错误code：0x80004005的。 一个OLE DB记录。来源：Microsoft SQL Server本机客户端10.0HRESULT：0x80004005说明：通信链路故障。 一个OLE DB记录。来源：Microsoft SQL Server本机客户端10.0HRESULT：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错误code DTS_E_INDUCEDTRANSFORMFAILUREONERROR。 输入目的地输入（62）失败，因为错误code 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：C DTS_E_PROCESSINPUTFAILED SSIS错误$ C $。该方法的ProcessInput的组件目标 - AGGSLIVE_Bandwidth，而处理输入目的地输入（62）（49）失败，错误code 0xC0209029。标识的组件从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：设置行集的缓冲区末尾失败，错误$ C C 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：C DTS_E_PRIMEOUTPUTFAILED SSIS错误$ C $。该PrimeOutput方法的组件源 - 查询（1）返回的错误code 0xC0209017。该组件返回失败code当管道引擎调用PrimeOutput（）。失败code的含义由组件定义，但这个错误是致命的，管道停止执行。有可能在此之前张贴与有关失败的详细信息的错误消息。  （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.

这篇关于如何解决DTS_E_OLEDBERROR。在SSIS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！