In SSIS when extract data from sources, data flow error output has 3 columns - Flat File Source error Output Column, ErrorCode, ErrorColumn
ErrorCode is a numeric code, we can use script component to do the transformation into Error Description by
using the method of the interface, available through the property:
public override void Input0_ProcessInputRow(Input0Buffer Row)
{
Row.ErrorDescription = this.ComponentMetaData.GetErrorDescription(Row.ErrorCode);
}
For the ErrorColumn, it is LineageID also in number, but for SSIS prior to 2016, there isn't
Then we can use merge join add the Column Name into the Error Output data flow.
阅读(1464) | 评论(0) | 转发(0) |