Sunday, December 05, 2010

SSIS Ouput Column Names for errors

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

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