Post reply

Exporting to Excel, how to convert SQL datetime to Excel time format?

  • March 3, 2009 at 2:14 pm

    #197661

    I'm trying to create an Excel file from a query, all in SSIS. I'm having trouble getting database datetime values to come over to Excel - by default it strips off the time value in the Excel destination.

    I've tried a derived column and a Data Conversion object, but am not really sure what format/datatype I should be using in the first place.

    What's the best most reliable way to get my database datetime values into Excel without losing info? Thanks!

  • March 5, 2009 at 2:48 pm

    #954457

    Bump? Anyone?

  • March 5, 2009 at 3:02 pm

    #954471

    Just curious...have you tried exporting the date and time as separate values/columns? You could use a derived column to split the datetime.

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

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