Invalid character for specified code page column 1

• Scubba-Steve

  Ten Centuries

  Points: 1373

  More actions

  June 2, 2015 at 12:34 pm

  #297429

  Hi SQL Central. I am working on a BULK INSERT Statement using a FORMATFILE and I am getting this error:

  Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 5, column 1 (logTime).

  Msg 4864, Level 16, State 1, Line 1

  The file I have has a datetime that has yyyy-mm-dd hh-mm-ss-ssss.

  Unfortunetly I cannot parse or split the data because we are wanting to use this column data to identify logfiles in multiple tables to aggregate data. What can I use as a datatype?

  --DATETIME EXAMPLE

  2015-04-30 00:46:00:9659

• Scubba-Steve

  Ten Centuries

  Points: 1373

  More actions

  June 24, 2015 at 7:40 am

  #1807738

  No help here hu?