February 6, 2009 at 1:44 am
Hello,
I am exporting data from a table in MS SQL server 2005. Some of my columns have float datatype and some of them are in this format: -5.00000000000003E-2.
How can I tell SSIS to export all my float values eg in precision 8 and no scientific notation?
I read on another thread by setting the datatype to [DT_NUMERIC] but this means I have to set this for each column seperate?? I have 8 export packages, which exports data from tables with +- 250 columns with all different datatypes. I don't want to manually check which field has float as datatype and set [DT_NUMERIC] for each column manually.
Also I noticed if I use this method, I get a value like this in my csv file: -.0500
Since I use this csv file to load in another database environment, he will flip on the missing 0 before the decimal.
Can somebody help me? I am looking for a setting like 'SET SCIENTIFICNOTATION OFF'
thanx in advance,
Best regards
May 14, 2009 at 7:14 pm
Hi, Did anyone ever find a solution to this? I sure could use a solution and the DT_NUMERIC didn't work for me.
May 15, 2009 at 7:15 am
My only experience of a problem like this was caused by users opening the csv file in Excel after the extract to edit the data - it was Excel converting the column to scientific notation, and if you saved the file when exiting, the text file was updated into the wrong format.
Extract the data to csv and try opening it in a text editor such as notepad to see what the format of the data is.
April 11, 2024 at 7:52 pm
Another typical case of Microsoft holding onto crappy settings set in their software in version 0.1 beta, now for 30 years. I hate Microsoft.
April 12, 2024 at 3:54 pm
Have you even tried using PowerBI? If that doesn't make you hate Microsoft, nothing will. There are bugs in the software that have been there for like 10 years. My personal favorite is the measure "help" that pops up supposedly context-sensitive help so that I can no longer see the text of the formula I'm trying to create. A+ for usability on that one.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply