Reject From DRS stage.

dhelsley · Post by **dhelsley** » Thu Aug 24, 2006 9:50 am

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.

thumsup9 · Post by **thumsup9** » Thu Aug 24, 2006 10:01 am

Whats your Array Size in DRS Input Stage

thumsup9 · Post by **thumsup9** » Thu Aug 24, 2006 10:07 am

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.

meena · Post by **meena** » Thu Aug 24, 2006 10:12 am

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

dhelsley · Post by **dhelsley** » Thu Aug 24, 2006 10:44 am

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.