The "Error Description" custom component for SSIS (SQL Server Integration Services 2005 and 2008) helps to enhance the error flows.
It provides error description, column name and other useful information.
You can connect many inputs to this component to create effective error flows quickly.
The component is available on Codeplex
http://eod.codeplex.com/
Normally SSIS provides only error code and error column where error column provides only the Lineage Id not the actual column name. The above component does the mapping between Lineage ID and Output Column ID and provides the Column name.
No comments:
Post a Comment