You said that abnormal rounding happens just some times,. Can you cite an example of your inputs and outputs for both successfully transfered and some rounded off. Also you might want to check the setting of the field of the sql server if it has the same
precsion as the oracle.

I wasn't able to repro your error, or I might be missing something. I'm not clear what are the values you presented, how were you able to arrive at those values? You said you got the wrong values when performing calculations like Field1/Field2.
What's the relevance then of Max(Field1)? Are you also not getting the correct values when using Max?

Thank you first of all,
I only showed you Max(Field1) as it is the max value in the result to be informative.
So I mean there are no big values in the transfer process. And I diminish the scale to 10 digits with Trunc command.

It's a very weird problem and I'm bored trying to solve it & I constantly work on it :(
Also, I forgot to point out in the first email, that when I'd run the transfer application without any changes, it'd been able to transfer 50.000 records correctly at once for a few times. Very strange!

Let's do this step-by-step: Verify if all I've written below are correct:

1. You read data from the Oracle database. Did you simply read data or performed some operation like Max?

2. You used a data reader to get the values. Did you verify that you got correct values?

3. You used sql command to insert the values in the sql database. Were the values inserted the same as the ones you read?

I'm asking all of these because I'm confused as at what point are you getting the incorrect values. Is it while executing an oracle statement or probably the datareader's not returning the correct values? If the above steps are incorrect, please
post the correct ones.

I'm a little confused. Correct me if my understanding is wrong, you've said that you verfied that the values returned from the oracle is correct using the using
Toad for Oracle. But after doing a query(using .NET), you're dataset now contains wrong values? So is there a gap between the results of the Toad and in the DataSet?

Yes, we did read that but I can't find the relevance as you are not using a datareader. Have you tried running the exact query on sql management studio? If you haven't, try it out first and see if you are getting the correct values. This
way, we could sort out if the problem is indeed with the populating of the dataset.