Getting float value ( URGENT PLZ)
Hi Gurus,
I have table with one column in sql table
data like
1
1.23
3.6578
i want out PUT like
1.0
1.23
3.6578
how can i achieve this. Where can i done changes. plz let me know
November 6th, 2011 6:05am
after the OLE DB Source, add a data conversion transformation, and change data type of column to double precision float DT_R8http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 6th, 2011 6:23am
HI Reza
i tried with DT_R8 but i am geeting same values. not added .0 in sedtination
i am geeting string datatype in oledb source
November 6th, 2011 7:43am
try Numeric, set the precision and scale to appropriate value toohttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 6th, 2011 7:49am
try Numeric, set the precision and scale to appropriate value toohttp://www.rad.pasfu.com
November 6th, 2011 3:47pm