DSXchange

I need help !

During insertion of rows to target I get errors . Primary key violation , datatype mismatch ... . I want to catch these error's rows and put to another table and may be create some metadata with DBMS code error.

How to do these ? For example, I see that 1000 rows are go into final odbc stage and onlu 5 are inserted to target and all others were with errors

From the transformer immediately in front of the ODBC stage simply add another output link per your DS manual (please read it). Simply set the constraint to have the reject box checked, and make sure the link is the last one in the execution order. Rejects from the database will come back to the tranformer stage and get directed to the [reject] link. I suggest you use a sequential file to capture the rows rather than another database table.

You may also have to set the commit size.

Search the forum for more info.

One setting you want to make sure is that the target stage's array size should be "1" if you want to capture the rows rejected by target.