Sergiy, no more questions and answers.  This is the "fish or cut bait" time.  Prove your point or concede.

Yes.  Now, stop dragging it out, and just prove your point, if you can.

I can't answer your question if I don't know the requirements.  That is why the answer to your question is "It Depends".  No requirements, no answer beyond that.

I am staying...

What answer is wrong?  The one that states It Depends or the one where this has no relevance to discussion about rounding.  You talk in half sentences and abstractions that...

The answer to your question: It Depends.  It depends on what you are tracking, why you are tracking it, so you can determine the approriate way to track it.

So that...

And you have been asked what does this have to do with rounding?

You obviously don't know how to do anything but attack people that disagree with you.  And your twisting of the phrase "minor in mathematics" is so tiring.  All that means...

I'll check with my co-worker. He does a lot of our SSIS package development and we have talked about standards, but I don't know if we ever got to the...

That version of SQL Server 2005 does not have SP 2 installed.  In the @@version, the service pack 2 mentioned, I believe, is for the OS you are running on. ...

Sergiy,

You must be living in your own world.  Anyone who takes the time to read all 126+ posts will come to the conclusion that we all gave up on you. ...

As another of the 5, here are my results of ten runs (sorry if it doesn't fit on one screen or wraps):

InitialTotal                            ConvergentTotal                         Traditionaltotal                        TotalRecords ConvergentCountDown ConvergentCountUp ConvergentCountSame ConvergentDifferene TraditionalCountDown...

Forgot about DATABSEPROPERTYEX, another good catch.

Any SSIS packages in 64-bit environment that using scripting will need to be precompiled before they are deployed.

Its been there.

No.  It is not.  I have installed SQL Server 2005 on several servers that do not have IIS installed.