如何在SSIS中获取ErrorColumn名称 [英] how to Get ErrorColumn Name in SSIS

问题描述

我们如何在SSIS包中获取错误列名。



在我的情况下，我使用数据转换转换，我将错误输出重定向到脚本组件。

我需要使用导致错误的columName记录错误输出。



如果您遇到此问题并成功解决，请帮助我。 ...



谢谢，

Amarnath

How we can Get Error Column Name in SSIS Package.

In my case i am using Data Conversion transformation and i am redirecting error output to Script component.
I need to log error output with the columName which cause the error.

Please help me if you face this issue and resolved successfully....

Thanks,
Amarnath

推荐答案

你得到了导致错误的行转储出错误输出。每行都有一个新的ErrorColumn列 - 对于您感兴趣的行，记录您在该列中看到的值。该值是遭遇报告错误的传入列的沿袭ID。



您可以使用高级编辑器查找具有沿袭ID的列...

但要以编程方式找到这个需要一些马戏团：



http://informatics.northwestern.edu/blog/edw/2012/01/etl-assistant-getting- error-row-description-and-column-dynamic / [ ^ ]



谢谢，



Kuthuparakkal

You get the rows causing the errors dumped out the error output. Each row will have a new "ErrorColumn" column - for the rows that you''re interested in, record the value you see in that column. That value is the "lineage ID" of the incoming column that suffered the reported error.

You may use advanced editor to find the column that has lineage ID...
But to find this programmatically needs some circus:

http://informatics.northwestern.edu/blog/edw/2012/01/etl-assistant-getting-error-row-description-and-column-dynamically/[^]

Thanks,

Kuthuparakkal

我使用Error列值为读取错误列名建立了新的自定义转换组件。您可以从以下链接获取DLL和源代码



https://naseermuhammed.wordpress.com/tips-tricks/getting-error-column-name-in-ssis/ [ ^ ]



谢谢

Naseer Muhammed AG

I builded new custom transformation component for read Error Column name using Error column value.You can get DLL and source code from the below link

https://naseermuhammed.wordpress.com/tips-tricks/getting-error-column-name-in-ssis/[^]

Thanks
Naseer Muhammed AG

你能否使用InputColumn的名字？ ？

如：

Can you use the name of InputColumn?
such like:

this.ComponentMetaData.InputCollection[0].InputColumnCollection[0].Name

希望这对你有帮助。

Hope this will help you.

这篇关于如何在SSIS中获取ErrorColumn名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！