I am using Bulk Insert to import large amounts of data into SQL tables. I have come across a problem when I need to insert date fields with the value "1899-12-30". Whenever such a field is imported, Bulk Insert generates an error saying "Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 2072, column 9 (LAST_AMENDED_DATE)."
I have tried changing the field type from smalldatetime to date time but hasn't been successful.
This is a sample row from the text file I am importing (pipes are delimiting the fields): -
Is there any way of going around this?