Invalid character for specified code page column 1

  • 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

  • No help here hu?

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

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