I have a Data Flow Task on Visual Studio 2008.
In this Task, I have a data written in a ADO NET Destination. In it, I have set 'Redirect row' in case of Error handling.
So, I have put a script component destination where I wrote error data in a table.
But: I have only ErrorCode and ErrorColumn fields for error info?
It seems that I have a detailed error in case of 'Fail component' in the ADO NET destination and only two numbers (and ErrorColumn is always 0) in case of 'Redirect row'?
1. Redirect row error data:
And I can obtain the description with:
errorDescription = ComponentMetaData.GetErrorDescription(Row.ErrorCode);
2. Fail component error data:
View Complete Post