November 4, 2008 at 10:00 am
I am working on a sql 2005 migration project in which i am trying to convert a DTS package to a SSIS package.
This package connects to text files and imports data to the database.
The problem is, in SSIS when i import data from the text file to the database, the values in some columns are not coming exact.
for ex. the value 6.60 in the text file is being populated as 6.59999990463257 in my SQL 2005 DB thru SSIS.
the destination data type is FLOAT here. this is happening in multiples tables with float columns.
Now, the DTS works absolutely fine. The destination datatype is also FLOAT in SQL 2000.
Can some one help here? Will changing the data type help?
November 4, 2008 at 12:25 pm
Float and real data types are noted as approximate values. use decimal or numeric with fixed lengths of decimal places for accurate numbers
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply