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 |
|
Carpend
Starting Member
7 Posts |
 Posted - 2010-04-08 : 03:33:03
|
| I've got a ssis package that inserts data from as CSV file into a SQL Server Database. If I run the package locally on my PC the package runs fine. If I run it through the sql agent the date gets inserted in a wrong format, instead of going in ddmmyyyy it goes in mmddyyyy. Does anyone have a solution to fix this? Thanks Dave |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-08 : 03:42:08
|
If the column in your targed table is a datetime type then don't bother because it is stored in an internal format and what you see if yo do a select is only a display issue.Otherwise we need more info.- dateformat in the file- type of column in table
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Carpend
Starting Member
7 Posts |
Posted - 2010-04-08 : 03:50:00
|
| Thanks for the quick reply,it's a display issue for example the if the date in the file is 07-April-2010 it goes into my Database as the 04-July-2010.The column type the data is going into is datetime and the Language on the database is English(United States). The date format in the file is this 07/04/2010 - Which is ddmmyyyy. I've the locale. |
|
|
|
Carpend
Starting Member
7 Posts |
Posted - 2010-04-08 : 03:50:33
|
| Sorry in the last post I meant to say this isn't a display issue. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-08 : 05:23:36
|
| are language settings same in local as well as server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSIS Date Import Problem