Hi Jude,
You can access the error description by passing the error code to the function GetErrorDescription (Pipeline.Wrapper.IDTAComponentMetaData90.ComponentMetaData.GetErrorDescription()).
I use a script component transformation:
Row.ErrorDescription = ComponentMetaData.GetErrorDescription(Row.ErrorCode)
S. Hasse