Redirection of failed rows to Error Table

Hi,

I know we can redirect a error to say an OLE DB Destination or textfile. Is there something we can do so that I can know seeing the error table the reason for which the row failed.

The Error table will look just similar to the destination table, but for one col which should hold the reason say 'Truncate error' etc...

Is this possible?

Thanks,

[389 byte] By [MShetty] at [2007-12-24]