Hi,
while loading the data in to sql server I am facing the below issue:
Input dataset values are 3.4455, 55.667, 333.44445
In sql server database it is loading like : 3.4400012, 55.6670122, 333.4444499999
But I need the o/p like: 3.44, 55.66,333.44 i.e i need the o/p precision 2 decimals.
And the datatype is float in the database (sql server) .
In Transformer stage i have used the decimal conversion option by giving scale 2 ,but for some of the values is loading properly, not all the records
Please advice me the handling process for above issue and any other alternative process .
Thanks in Advance
rounding issue while loading in to sql server
Moderators: chulett, rschirm, roy
What is your source data type, are you doing an implicit conversion to float in the transform stage?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Would it be possible to remove the character conversion from the process and stick with numeric values? This would make it simpler (and faster).
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: