Post reply

Date Formats....

  • July 9, 2008 at 5:54 am

    #122396

    Hi,

    I have some issues.. I have an SSIS package that simply loads data from a csv file to a SQL table.

    The csv date is in the format dd/mm/yyyy and the table is datetime.

    When I run the package from my XP machine, the date format loads correctly. When I have deployed and run it through SQL Agent, it loads it as mm/dd/yyyy. I have checked the regional settings on the server and made sure that they are the same as the client, but still no dice.

    Any suggestions much appreciated

    Thanks

    Mike

  • July 9, 2008 at 6:23 am

    #840033

    Regional settings are part of the user profile. Did you log in as the SQL Agent service account when you checked the server?

  • July 9, 2008 at 6:27 am

    #840037

    Nope, I just logged in with the service account, I've also noticed that the SQL server language is US english, which may be part of the problem. I understand it's not easy changing that, but can I do it per user?

    thanks for the help

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply