Monday, August 28, 2017

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

SSIS - Advance Editor
Advance Editor


·         Click on “Input and Output Properties” tab

SSIS - Input and Output Properties
Input and Output Properties


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





Thanks for visiting!!


No comments:

SQL Server - Identify unused indexes

 In this blog, we learn about the index usage information (SYS.DM_DB_INDEX_USAGE_STATS) and analyze the index usage data (USER_SEEKS, USER_S...