Post reply

Importing data with DTS

  • August 8, 2004 at 12:37 pm

    #164578

    I'm trying to import a comma delimited file with the following date format 2004/08/06 09:40:07.994 into a field that uses the datetime datatype.  I try to use DTS but it's not working, giving me an error message saying the format's wrong.  Any help would be greatly appreciated.

    Thanks.

  • August 9, 2004 at 10:46 am

    #518230

    Look at "Date Time String Transformation" in Books On Line.  You'll need to edit the transformation for that field and make the source and destination date format yyyy-MM-dd hh:mm:ss.ffff.

    Greg

    Greg

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

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