DSXchange

Posted: **Wed Apr 16, 2014 5:38 pm**

How to terminate a job if the Surrogate Key value reaches the max value be it signed/unsigned 32/64 bit while processing a single dataset.

Thanks !

Posted: **Thu Apr 17, 2014 1:03 am**

Use a Tranformer and put your condition as link constraint, user the "Abort After Rows" property, set it to 1 and the job will abort when there is even a single row for which you SK is greater than the preset value.

DSXchange

Abort job when exceeding limit on a Surrogate Key value

Abort job when exceeding limit on a Surrogate Key value