Thank you very much for your help.

Thank you very much for reply. That explains it. It seems like the only option I have is doing pre-audits (something like a lookup transformation in SSIS or joins in...

I was looking for a way to rely on constraints defined on the target table to reject rows. Not auditing data before the load.