DSXchange

New installation ?

Were you able to compile earlier ?

Server or ll routine ?

What about the jobs that do not access from RDBMS or load back into them ?

You reconciled with what? How did you get the numbers?

Can you put together a test of where it breaks ?

I have not been through your links so far. But do very much appreciate your effort.

Alternatively you can append a dummy line to incoming file, locating the presence of which in your input stream will determine end-of-file.

Do you have a "wait for file" ?

Do you have any insert trigger?

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

There are different methods - even discussed here before.

What have you tried so far ?

Search for pivot.

There is also an FAQ about this.

Maybe due to missing or unconfigured c++ compiler.

Search for "compiler error"

or simply sort the incoming data and append to existing using stage variable. Something like sort input -> tx -> hashed file and in tx do yourStgField = if (prevKey = Key) then inField Else yourStgField : delim : inField where yourStgField is a stage variable.

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.