SQL Server Performance

excel import / date format

Discussion in 'SQL Server 2008 Integration Services' started by dropout, Mar 24, 2010.

  1. dropout New Member

    Hi all
    Got a stupid problem with the import of a date column from a excel-file to my sql-server.
    The date (Month and Day) gets switched when possible. here some examples:
    • 22.02.2010 -> 22.02.2010 (gets imported correct)
    • 12.02.2010 -> 02.12.2010 (dd and mm are mixed up after import)
    I have a dataflow task: Excel-Source -> Dataconverter -> SQL-Server-Target
    The Preview of the Excel shows the correct date. But the Preview of the SQL-Target shows already the wrong dates.
    How can I fix this problem?
    Any help appreciated. Thx.
    Greetings Reto
  2. dropout New Member

    Me again
    I figured it out. After I have added a derived column task, where I convert the DT_DATE to DT_DBTIMESTAMP it gets imported correctly.
    Cheers Reto
  3. satya Moderator

    Good job and appreciate your feedback here again, not all enthusiastic learners like you do that... keep it up. BOL is best friend.

Share This Page