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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics