I created a simple transformation that extracts data off a Excel Input, do a database join against a master table and loads into another database table when the join is successful.

Unlike database lookup step, db join step does not have a "do not pass the row if the lookup fails" option. Even if row 10 out 100 fails the db join, I want to stop the transformation and move the input file to an archive location.

I tried using the Abort step after enabling the error handling option for the db join step but I am getting unexpected result.

Is there a way to reject input file if db join step FAILS?

I welcome your suggestions. Thanks.