SSIS - Error Code and Error Column

SSIS automatically creates two columns on the Error output from data flow components

1.       ErrorCoulmn

2.       ErrorCode 

Error Code – it contains the error number that caused the row to be rejected. You can find the list of error code at http://msdn.microsoft.com/en-us/library/ms345164%28v=sql.100%29.aspx

Error Column – it contain the column ID of the flawed column and that Column ID is unique to a dataflow within package.

You can easily find actual associated Column Name for Column ID.

·         Open the Advance Editor of error associated component

Advance Editor

·         Click on “Input and Output Properties” tab

Input and Output Properties

·         View all Input Columns, you can find the matching column ID.

Thanks for visiting!!