Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stranter
Starting Member
17 Posts |
 Posted - 2009-10-29 : 05:30:27
|
Hello,Our SQL server was originally installed as English (United States) and due to various reasons we didn't immediately change it to English (United Kingdom).Because of a license key issue with a third party piece of software, we had to change the locale of the server to English (United Kingdom).I have ran:EXEC sp_configure 'default language', 23 RECONFIGURE andSET Language British Additonally, I have also ensured all SQL Server logins are using English (British) as their default language.We have an SSIS package which does various things with some import data, including some date functions in VB and T-SQL. I have converted this to "do its stuff" in a British way, i.e. dd/mm/yyyy. If I am logged on to the SQL server and run the package in Visual Studio, it works fine.  If I schedule the package in a job, the package fails, complaining of not being able to convert String to Date - the date in question being 28/10/2009 - a valid British date, but obviously not a valid US date.  Do I need to restart SQL Server services or the server?Thanks,Stewart |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-10-29 : 14:16:12
|
| make all your dates like this '20091030' |
 |
|
|
|
|
|
Server locale and date problems