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
    dropout, Mar 24, 2010
    #2

  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
    dropout, Mar 24, 2010
    #3

  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.
    satya, Mar 24, 2010
    #4

Share This Page