August 30, 2016 at 10:41 am
Hello,
i have created a Data transformation task that sends the contents of a table to a flat file, but some of the numbers end up having Exponential notation at the end. How can i stop this from happening?
I tried creating a view and converting it to differnt values but it always end up with the notation. It was also changed in DTS without succes
Example:
0.0500000008032566
ends up as:
5.0000000803256624E-2
Some of the numbers really need to have 13 decimals
Please advise how to get rid of the E-2
August 30, 2016 at 12:18 pm
You'll need to use a decimal data type. Exporting a float to a text file gives exponential notation.
August 31, 2016 at 3:12 am
Hi Douglas,
thank you. The problem with this is that numbers less than zero show up as without the zero (example:.0500000000000)
How can i get it to show 0.0500000000000
August 31, 2016 at 4:23 am
What application are you using to view the flat file?
August 31, 2016 at 8:07 am
notepad
August 31, 2016 at 6:25 pm
Check Regional Settings, see what the 'leading zeros' is set as.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply