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 |
|
lampis
Starting Member
10 Posts |
 Posted - 2011-09-22 : 10:48:10
|
| Hello,In my database I want to import data from a .csv file. I do this by importing by "flat file" using the "Import and Export Data" tool for SQL Server Management Studio. This works without problems. When this is done, I save the import as a SSIS-package (so that I can re-do imports later).The SSIS-package is run from a share on a web hotel where the SQL Server is located. I run the package through the SQL Server Agent in Management Studio. The data is on the form "1.xx" or "0.xx". However, when I run this package as a job by Server Agent I lose the decimal separators. Hence I get "1xx" or just "xx" as values.Does anyone know why this happen? How can I avoid this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-22 : 11:37:43
|
| is the job using a different account which has different language locale setting?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
lampis
Starting Member
10 Posts |
Posted - 2011-09-23 : 04:31:14
|
quote:
Originally posted by visakh16
is the job using a different account which has different language locale setting?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
I'm not sure. I use a SQL account that I got from the database team at my company, to be able to run Server Agent. Maybe the settings on the account/SQL server is different from my local settings? I use swedish... they probably use english. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-23 : 05:29:30
|
| yep. first check that. it can difference in format in which it displays some data for example currency,dates etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Decimal separator disappears with server agent/SSI