SSIS错误：尝试将行添加到数据流任务缓冲区失败，错误代码为0xC0047020 [英] SSIS ERROR: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020

问题描述

我在SSIS流程上遇到问题（对于两个不同的流程，确实发生了相同的问题）。因此，我们正在使用SSIS进行一些ETL工作。我们有一个商业智能项目，该项目可以在Visual Studio中正确执行。但是，当将其部署在服务器上并作为作业进行调度时，它将失败，并显示以下错误：

I have problems with SSIS process(acctually the same problem occurs for two different processes). So, we are doing some ETL work using SSIS. We have Business Intelligence project that executes without errors from Visual Studio. However when its deployed on the server and scheduled as a job it fails with errors like:

INTRASTAT_Towar:Error: SSIS Error Code
DTS_E_PROCESSINPUTFAILED. The ProcessInput
method on component "Union All 3" (876) failed with error
code 0xC0047020 while processing input "Union All Input
2" (916). 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.

INTRASTAT_Towar:Error: SSIS Error Code
DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput
method on istat_dekl_wynik_poz SELECT 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.

INTRASTAT_Towar:Error: The attempt to add a row to the
Data Flow task buffer failed with error code 0xC0047020.**

其他返回的错误类似，有时不是未指定的错误，而不是0xC0047020。错误仅发生在此一张表上，该表在数据流任务中有很多不同的内容（联合，多播，条件拆分）。大多数其他数据流仅具有源，目标和转换，并且不会引起任何问题。建议我尝试为数据流任务处理 DefaultBufferMaxRows 和 DefaultBufferSize 属性值，但是经过一些研究，我不相信它将解决问题，因为它们当前设置为默认值。有什么建议吗？

The other returned errors are similar, sometimes instead of 0xC0047020, there is unspecified error. Errors occur only on this one table, that has a lot of different stuff inside data flow task(unions, multicasts, conditional split). Most other data flows have just source, dest and transformation, and they are not causing any problems. I've been suggested to try manipulating DefaultBufferMaxRows and DefaultBufferSize properties values for the data flow task, but after doing some research I dont belive that it will solve the issue, as they are currently put on default values. Any suggestions?

推荐答案

好吧，我设法通过软件包解决了这个问题。我使用的是2012 SSIS版本，但是我在BIDS的32位环境中执行了程序包。服务器正确地以64位执行，对于某些项目，这就是问题所在。步骤属性中的一个复选框可以使其在32位环境中执行，我解决了我们为之奋斗数周的问题。

Well, I managed to work the issue with my packages. I was using 2012 SSIS version, but I executed packages in 32 bit environment in BIDS. The server acctually executed in 64 bit and for some projects that was the problem. One checkbox in step properties to make it execute in 32 bit env and I solved the problem we have been fighting for weeks.

这篇关于SSIS错误：尝试将行添加到数据流任务缓冲区失败，错误代码为0xC0047020的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！