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