Post reply

Data Conversion - returning NULL

  • March 21, 2007 at 9:53 am

    #194798

    Hi,

    My input is  in  "03/20/2007 13:30:26.847"  format and should be populated to a DATETIME field. SSIS is not converting (using DATA CONVERSION) and returning NULL.  I tried converting the input to  DD/MM/YYYY hh:mm:ss , that also didn't  work.

    I have tried DT_DATE, DT_DBDATE ......  but dataviewer windows shows  it to be null

    What I am doing wrong?

     

    Deepak

     

  • March 22, 2007 at 4:30 am

    #696323

    This is maybe not the best option. But I needed to do a similar thing yesterday and ended up converting the input string to a 19 char string.  This way the milliseconds are chopped off and th input can be implicity cast to datetime.

     

    ola

  • March 22, 2007 at 9:24 am

    #696408

    Have you tried converting to DT_DBTIMESTAMP

    Kindest Regards,

    Frank Bazan

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

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