My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Setting the error output on a SSIS Component
The new RSS feed is here
If you've used SSIS you must have used data flows and probably come across the error output of components.
As it's name suggest it contains the rows that fail. However by default (most if not all components) are setup to fail when an error occurs, to alter this behaviour you go in to the settings for the error output and for each column define what should happen. You can say for each column whether an error should fail the component, be ignored or redirect the row. This also applys to truncations (trying to put too much data in a buffer column).
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Setting the error output on a SSIS Component