I am using a DRS stage to insert into MSSQL table via an ODBC connection. When a duplicate is encountered I expect the "reject" link from the transform feeding the DRS stage to trigger if the insert fails but it does not. In fact the job log does not even show an error.
If I replace the DRS stage with an ODBC stage everything works as expected.
Hi
Are using "Insert new rows option" in Update action Insert new rows only: Inserts the new rows in the table but
does not report duplicate rows to the log