SSIS PrimeOutput 错误? [英] SSIS PrimeOutput Error?

问题描述

我们的 SSIS 作业已经运行了一年多，没有出现任何问题.该作业从 oracle 数据库中的 select 语句中获取数据集，并将结果传输到 SQL Server 2005 实例上的表中.

We have an SSIS job that has been running for over a year with no issue. The job takes a data set from a select statement in an oracle db and transfers the result to a table on a SQL Server 2005 instance.

截至今天早上，我们收到以下错误消息:

As of this morning, we receive the following error message:

错误:2010-05-26 05:06:47.71 代码:0xC02090F5 来源:[job_name] DataReader Source [793] 说明:组件DataReader Source"(793)无法处理数据.结束错误错误:2010-05-26 05:06:47.71 代码:0xC0047038 来源:job_name 描述:SSIS 错误代码 DTS_E_PRIMEOUTPUTFAILED.组件DataReader Source"(793) 上的 PrimeOutput 方法返回错误代码 0xC02090F5.当管道引擎调用 PrimeOutput() 时，组件返回失败代码.失败代码的含义由组件定义，但错误是致命的，管道停止执行.在此之前可能会发布错误消息，其中包含有关失败的更多信息.End Error Error: 2010-05-26 05:06:47.71 Code: 0xC0047021 Source: P... 包执行失败... 步骤失败.

Error: 2010-05-26 05:06:47.71 Code: 0xC02090F5 Source: [job_name] DataReader Source [793] Description: The component "DataReader Source" (793) was unable to process the data. End Error Error: 2010-05-26 05:06:47.71 Code: 0xC0047038 Source: job_name Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "DataReader Source" (793) returned error code 0xC02090F5. 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. End Error Error: 2010-05-26 05:06:47.71 Code: 0xC0047021 Source: P... The package execution fa... The step failed.

有人知道根本原因可能是什么吗?

Does anyone know what a root cause might be?

推荐答案

可能会发布错误信息在此之前有更多信息关于失败.

There may be error messages posted before this with more information about the failure.

您是否查找过其他更具体的错误消息?

Did you look for other more specific error messages?

您是否在运行时记录错误或步骤?如果是这样，您是否查看了日志记录表?如果您没有登录您的 SSIS 包，我会将其设置为此修复程序的一部分，这将大大加快发现问题的速度.

Are you logging errors or steps as they run? If so did you look in the logging table? If you aren't logging in you SSIS package, I'd set that up as part of this fix, it will make it immeasurably earier to find the problem.

我会考虑的事情:架构更改、权限更改、任何最近的软件、所涉及服务器的操作系统更新、数据不匹配(也许是第一次 Oracle 表保存了无法插入 SQL 表的数据 - 检查不直接匹配的列)首先，可能会被截断的字符串数据，存储为需要转换为日期时间的字符串的日期等).

Things I would consider: schema changes, permissions changes, any recent software, operating systems updates to the servers involved, data mismatches (the first time perhaps that the Oracle table held data that couldn't be inserted into the SQL table - check columns that don;t directly match first, string data that might get truncated, dates stored as strings that need to convert to datetime, etc.).

这篇关于SSIS PrimeOutput 错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！