Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS issue on decimal target value Expand / Collapse
Author
Message
Posted Tuesday, January 22, 2008 1:09 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 20, 2014 3:12 PM
Points: 146, Visits: 141
I have a source table using an iSeries ODBC and a target table using Sql Server.
The source column is a packed data type (7,2) going to the target column decimal data type (7,2).

If the actual source value is "79.99", the target value is "79.99".
If he acutal source value is "79.90", the value in the target is "79.9".

Why does it not show the hundreth numeric placeholder value if zero.

Quick Update: This is probably not a DTS issue. I was reviewing the data in QA; and I added a new data row and the result is the same. Does not show ending zero.



Post #446084
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse