I have a simple lookup that is configured to redirect row on error. I've set up an OLE DB command on the Lookup Error Output to write the flawed rows to a table.
The lookup gets 300 rows on its input, it outputs 226 rows on its main output and NO rows on its error output and it doesn't raise any errors. I've checked it also with data viewers. Memory restriction is not enabled.
Since I'm having multiple lookup transformations on the same table (for different purposes) in the same data flow, and I know SSIS has its problems with that, for this lookup I've used results of an SQL query (that even changes table name and columns just to be sure I've fooled SSIS) instead of table.
Why the rows are not being redirected? They simply disapear at this point in the dataflow.
many thanks!