SSIS错误代码DTS_E_INDUCEDTRANSFORMFAILUREONERROR。 “组件”派生列“ (373)"失败,因为错误代码0xC0049062发生,错误行处置“输入列”INSTALLMENT_NUMBER_OF_PAYMENTS" (1074)"指定错误失败 [英] SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Derived Column" (373)" failed because error code 0xC0049062 occurred, and the error row disposition on "input column "INSTALLMENT_NUMBER_OF_PAYMENTS" (1074)" specifies failure on error

查看:218
本文介绍了SSIS错误代码DTS_E_INDUCEDTRANSFORMFAILUREONERROR。 “组件”派生列“ (373)"失败,因为错误代码0xC0049062发生,错误行处置“输入列”INSTALLMENT_NUMBER_OF_PAYMENTS" (1074)"指定错误失败的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好,

我正面临着这个SSIS包问题。有一个SSIS是我项目的月度报告。上个月,该套餐运行顺利,没有任何问题。但是,当我们试图在本月运行它时,它会发出此错误。

I am facing this SSIS package issue. There was one SSIS which is a monthly report for my project. For last month the package has run smoothly without any issue. But, when we try to run it for this month it is giving this error.

起初我认为这是由于列数据类型,但如果是这样,它不应该运行任何月。它在上个月成功运行,但是给出了本月的错误。

At first I thought this is due to the column data type, but if so it should not run for any month. It is successfully running for previous month but giving the error for this month.

对此的任何帮助都将非常感激。

Any help on this would be much appreciated.

提前致谢。 !!!

推荐答案

您好SangamD,

Hi SangamD,

请分享您的数据流的一些其他详细信息任务。屏幕截图会有所帮助。

Please share some additional details for your Data Flow Task. A screen shot would be helpful.


  • 您的来源是什么?
  • 您在派生列转换中使用的是什么表达式?

您可以使用SSIS 数据查看器来查看和分析数据,特别是  INSTALLMENT_NUMBER_OF_PAYMENTS列,在进入失败的
派生列转换之前流经SSIS管道。

You can put SSIS Data Viewer to see and analyze the data, specially the INSTALLMENT_NUMBER_OF_PAYMENTS column, flowing through the SSIS pipeline before it goes to the failing Derived Column Transformation.

如何在DataFlow任务中使用SSIS数据查看器


这篇关于SSIS错误代码DTS_E_INDUCEDTRANSFORMFAILUREONERROR。 “组件”派生列“ (373)"失败,因为错误代码0xC0049062发生,错误行处置“输入列”INSTALLMENT_NUMBER_OF_PAYMENTS" (1074)"指定错误失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
相关文章
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆