SSIS 2005 Derived Column Rounding/Truncation Error Multiplying High Precision Numbers - by 135AVIATOR

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 617173 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/27/2010 12:35:57 PM
Access Restriction Public


Using SSIS / BIDS 2005, when a new column is created using the Derived Column transform, and the new column is the result of multiplying two numbers, at least one of which is a high precision number (lots of numbers to the right of the decimal point) and at least one of which has been retrieved from a database, then the resulting value may be rounded to the tenth's place (one digit to the right of the decimal) instead of displaying the full precision.  For more detailed information on the problem found, the exact tests run and test cases which illustrate this problem please read the following thread on the MS SQL Server SSIS forum:
Sign in to post a comment.
Posted by Microsoft on 12/15/2010 at 1:52 PM

thanks for reporting this issue.

I tried to test it by the repro steps you provided and it did not reproduce for me on either SQL 2005, 2008 or the latest build. I used builds with the latest SPs and all cumulative updates for 2005 and 2008 versions.

Could you update your product version to the latest service pack and see if that fixes this issue?

Best regards,
Bob Bojanic, SSIS Team