SSIS-Error“由于潜在的数据丢失而无法转换该值”。 [英] SSIS-Error "The value could not be converted because of a potential loss of data".

问题描述

我正在尝试将数据从DB2（源）表转换为Sql（目标）表。

执行我遇到错误的任务： -



错误＃1

[OLE DB源[1525]]错误：有一个输出OLE DB源输出（1535）上的输出列ABC（1545）出错。返回的列状态为：由于潜在的数据丢失，无法转换该值。。



错误＃2

[OLE DB源[1525]]错误：SSIS错误代码DTS_E_INDUCEDTRANSFORMFAILUREONERROR。 输出列ABC（1545）失败，因为发生错误代码0xC0209072，并且输出列ABC（1545）上的错误行处置指定错误失败。指定组件的指定对象发生错误。在此之前可能会发布错误消息，其中包含有关失败的更多信息。



错误＃3

[SSIS.Pipeline]错误：SSIS错误代码DTS_E_PRIMEOUTPUTFAILED。组件OLE DB Source（1525）上的PrimeOutput方法返回错误代码0xC0209029。当管道引擎调用PrimeOutput（）时，组件返回失败代码。失败代码的含义由组件定义，但错误是致命的，管道停止执行。在此之前可能会发布错误消息，其中包含有关失败的更多信息。



请求!!!!!!!!!!!

解决方案

Quote：

返回的列状态为：由于潜在的原因，无法转换该值数据丢失。。

嗯，目标表中的列对于数据来说是小的。例如。源中的varchar（255），但目标中的varchar（10）。

解决方案：确保目标表的列定义满足数据的空间要求。

Hi,

I am trying to transffer data from a DB2(source) table to Sql(destination) table.
While execute the task I am getting below errors:-

Error# 1
[OLE DB Source [1525]] Error: There was an error with output column "ABC" (1545) on output "OLE DB Source Output" (1535). The column status returned was: "The value could not be converted because of a potential loss of data.".

Error# 2
[OLE DB Source [1525]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "ABC" (1545)" failed because error code 0xC0209072 occurred, and the error row disposition on "output column "ABC" (1545)" 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.

Error# 3
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1525) returned error code 0xC0209029. 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.

Pleas hele !!!!!!!!!!!

解决方案

Quote:

The column status returned was: "The value could not be converted because of a potential loss of data.".

Well, the column tín the target table is to small for the data. E.g. a varchar(255) in the source, but a varchar(10) in the target.
Solution: Make sure that the column definitions for the target table meet the space requirements of the data.

这篇关于SSIS-Error“由于潜在的数据丢失而无法转换该值”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！