January 22, 2008 at 1:09 pm
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.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy