DSXchange

is there any way to load 1 row at a time?

and also if no of keys are increased then i observed more records are getting inserted.

but i can not treat all fields as key fields.

and I added most non null fields as key fields

Sainath.Srinivasan wrote:To solve, you must find the missing rows and the reason why they are being ignored.

You can
a.) clear the 3rd party s/w and insert the 900 rows successfully loaded again.
b.) load 1 row at a time and see which row fails.

Without seeing your table defn. and dataset it is not feasible to comment.

Define same table in the temporary as your target withh all indexes and constaints on. Try oracle stage to upsert the data into this table . From director log you will found how many rows got inserted and how many rejected or update.

my stored procedure is using data from temp table itself.
and i think i cant use oracle stage to upsert the data as i m using microsoft sql server

girija wrote:Define same table in the temporary as your target withh all indexes and constaints on. Try oracle stage to upsert the data into this table . From director log you will found how many rows got inserted and how many rejected or update.