Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


1
0
Sign in
to vote
Type: Bug
ID: 617173
Opened: 10/27/2010 12:35:57 PM
Access Restriction: Public
1
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/765943d2-4723-4dfc-be0c-f3d035781f5b
Details
Sign in to post a comment.
Posted by Microsoft on 12/15/2010 at 1:52 PM
Hello,

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
Sign in to post a workaround.
Posted by 135AVIATOR on 10/27/2010 at 12:36 PM
The workaround is to perform calculations in SQL Select statements not in the Derived Task if high precision is required for multiplied values.