How do I convert the ErrorCode and ErrorColumn in SSIS to the error message and column name?

Error message list is in the following location: MSDN, Integration Services Error and Message Reference https://docs.microsoft.com/en-us/sql/integration-services/integration-services-error-and-message-reference?view=sql-server-ver15

And column Id Number can be found in SSIS's Data Flow Task: select the task component that generates the error, Advanced Editor, 'Input and Output Properties' tab, External Columns Properties.

Part of the question (adding the error description) can be achieved with a script component. This is described in Enhancing an Error Output with the Script Component.

It seems that the Dougbert blog has a solution to adding the column name, but it's far from simple. I'm amazed this is so difficult to do in SSIS; you'd think it was a basic need to know the name of the source and column.

There is a far simpler answer. Simply redirect the error output to a new destination file (CSV or whatever) and then enable a DataViewer on the error output....