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
Target database insert errors
Moderators: chulett, rschirm, roy
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom