This Video Tutorial illustrates how to do Error Logging in Data Flow with Error Ouput Configuration.
Most of the Data Flow components has an special output named Error Output. Error Output when we configure it to redirect error rows, would contains; the record that caused error, the Error Column and Error Code. Error Column in most of the cases would return Data LineageID of the column in data flow. the ErrorCode can be used to fetch Error Description.
In this video you will learn how to configure Error output to get the record that caused failure in data flow. you will also learn how to translate errorCode to error description with script component and ComponentMetaData object. you will also learn that error description sometimes is not detailed ENOUGH. so you might use other ways of logging like SQL Server Profiler to catch the detailed error message. the Data Flow Discovery component from the link at the end used for this demo: http://dfld.codeplex.com/