DSXchange

re-index of the project might help.

In order to aviod dealing with record commit, best design would be source(primary)------>lookup1<__________(lookuptable)table1 lookup1(output link)------------>Dataset for insert lookup1(rejectlink)--------------->Dataset for update in the next job, use the Datasets to insert and update the table. I...

Take out the sort stage and do the hash partition and perform the presort on the Input tab in remove duplicate stage.

Looks like your target field datatype is double/dfloat after the transformation.
Can you try making it Integer 10

Do you have any After-Job subroutine in the job

I prefer doing thru the transformer. In the new version greater tha 8, there is no filter stage.

Do the NULL validation for DSLink77.TIN_NUMBERS before using it in the constraint