Converting Number to float
Do not use float as it is approximately calculation, instead use DECIMAL, SELECT CAST(1 AS FLOAT) 1Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
November 6th, 2011 11:39am

you can also change data types with Data Conversion Transformation in SSIS Data Flow taskhttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 6th, 2011 2:20pm

Hi, I am creating an SSIS package, My source DB is ORACLE and destination is SQL Server 2008. I geeting number filed from oracle and i want to change the number to float. like 1 in oracle ------> 1.0 in sql how can i achive this. i tried with data converion but not sucess. plz let me know the solution
November 20th, 2011 3:35am

SELECT CAST(1 AS DECIMAL(5,1))Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2011 3:38am

HAI, Uri Thanks for ur replay..... can we use float insted of decimal
November 20th, 2011 3:58am

Do not use float as it is approximately calculation, instead use DECIMAL, SELECT CAST(1 AS FLOAT) 1Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2011 4:26am

you can also change data types with Data Conversion Transformation in SSIS Data Flow taskhttp://www.rad.pasfu.com
November 20th, 2011 7:07am

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

Other recent topics Other recent topics