thank you. I have done pretty much what you have, three outputs. then i'm doing a union all from input 1, 2 and 3. 1 = deleted, 2 = new...

That is what i'm doing. The new goes to the union all and 'changed' goes to ole db command where i say, under component properties -

sql command:

UPDATE tblproductassignment

SET CurrentRecordInd =...

Thanks, but i was able to use this and resolve the problem. FYI, you can follow this if anyone else is running into the same issue.

http://agilebi.com/jwelch/2008/09/05/error-redirection-with-the-ole-db-destination/

My issue...

Thanks. Yes, we have already set it to 'redirect row'. It is currently redirecting rows to the error table, but the issue is that it redirects like a 'batch' of...

We just have the 'red' arrow going to error table, listed as OLE DB Destination Error Output. Is this what you mean?