Data flow transformation to extract columns error information.
Most of the SSIS data flow components have an error output that allows you to redirect rows that caused errors to a error logging destination. The quality of the information provided by the error output is rather limited. You get: the id of the column that's causing the error, the id of the error and all the input columns of the component. So what’s wrong with that?