March 27, 2012 at 10:28 am
I have a set of data from Turkey, using the ISO8859-9 character set.
My server is English ISO8859-1 (I believe, it's definitely UK English).
My design surface in SSIS tells me that Locale ID 31 is not installed.
Can I simply add this to Windows without messing up our current default?
(I hope that a system locale can co-exist with several input locales)
If so, is there a direction somebody can point me in to see how it is done?
TIA.
---------------------------------------------
If data can screw you, it will; never assume the data are correct.
March 31, 2012 at 11:36 am
[SOLVED] An additional language can be added to the OS, without changing system default.
Then the correct locale can be selected in the souce connection and it takes care of nasty thousand/decimal seperators and date formats.
Nice!
---------------------------------------------
If data can screw you, it will; never assume the data are correct.
April 1, 2012 at 11:42 pm
KevinGurney (3/31/2012)
[SOLVED] An additional language can be added to the OS, without changing system default.Then the correct locale can be selected in the souce connection and it takes care of nasty thousand/decimal seperators and date formats.
Nice!
Thanks for posting back the solution!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply