A view is exported weekly by a job, into a text file, using a DTS package. I created the DTS package using the Import Export Wizard.
The decimal separator in the output file is a comma (,).
How can I make it a dot (.) ?
I tried changing the LocaleId property of the Dataflow box to English (United States), with no result.
I tried the same on destination table's LocalId property, no result.
What else, George ??
You can convert the column to a varchar, making it locale-agnostic, and use string functions to replace the comma with a dot.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments