Post reply

Datatype Issue ..SSIS

  • March 5, 2013 at 5:47 am

    #269279

    HI,

    I have a task in ssis which loads data into DB from Source Files on my Drive, Issue is :

    i have to convert DATA TYPE of one column having data type of VARCHAR() to DATETIME.

    But when convert it into DT-DATE , it give me ERROR "OVERFLOW" but same conversion is done in sql server.

    Why this conversion is not happening on SSIS LEVEL ?

  • March 5, 2013 at 10:04 am

    #1593547

    Try DT_DBTIMESTAMP

  • March 6, 2013 at 7:36 am

    #1593961

    I think I faced this situation before and what I did (maybe is not the smart way) is to parse the strings using an expression in a Derived Column component. You will need a couple of tricks like the RIGHT function to force a leading zero for the month and days if they have only one digit, but at the end it is not so difficult.

    Let me know if you have further questions.

    Kind Regards.

    Paul Hernández

  • March 11, 2013 at 10:28 am

    #1595657

    Dear Rookie

    ur advice did the trick.thanks

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

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