Error Output from OLE DB Command

Hello everyone,

I have a problem with OLE DB Command and its Error Output.

I want to log error message and data from current row during OLE DB Command execution in case an error happens. I connected error output of my OLE DB Command to OLE DB Destination (I tried connecting it to other components too) but nothing goes from OLE DB Command to OLE DB Destination in case of an error (I added a trigger which trows exception to simulate error situation). I set "Row Redirect" for connection between those two components but still nothing happens.

Is there anyone who has experience with this and who can tell me how to get anything from Error Output of OLE DB Command component?

Cheers,
Sasa

[736 byte] By [SasaPopovic] at [2008-1-10]