DSXchange

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.

Is this an issue with the DRS stage?

Thanks.

Whats your Array Size in DRS Input Stage

I wanted to see if you can you write the rejected rows to a file. See if thats happening. Set the Array Size in DRS to 1.

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

BINGO.

Yes, I was using "Insert new rows only". Changing it to "Insert Rows without clearing" did the trick.

Thank you.

Also, array size is 1. I can't get them to reject to a file. That was the original problem.