Datatype Issue ..SSIS

  • 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 ?

  • Try DT_DBTIMESTAMP

  • 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
  • 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