SSIS : Enhanced Error Component - Update - SimonS Blog on SQL Server Stuff

SSIS : Enhanced Error Component - Update

I have finally got round to looking into the error reports and found a few bugs in this component.

I have uploaded a new install for this component including the fixes. The component now validates correctly that the correct inputs are attached to the component.

The key to using this component is to attach two outputs from the upstream component, the error output and the normal output. The normal output should be connected to the passthrough input of the enhanced error component and the error output connected to the error input.

The enhanced error component uses the normal output during the pre execution phase to map the column LineageIds to column names, after that the normal output is not touched it just passes through the component, thus the name of the input.

I hope explains how the component should be used.



-
Published 28 June 2007 00:55 by simonsabin

Comments

28 June 2007 16:10 by Ron McKay

# re: SSIS : Enhanced Error Component - Update

I would REALLY like to use this as it sounds like something I have been looking for.

IS THERE ANY DOCUMENTATION?  WHERE?

Thanks