Bulk insert a text file with date format issue

[borgkling2003]

Im getting this error when I try doing a bulk insert:

Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 2, column 3 (last_sales_date).

This is how the txt file looks like:

ID,NAME,LAST_SALES_DATE
----------------------
10|Terry|30/06/1999

In the database the LAST_SALES_DATE field type is set to DATETIME.


Can someone please help me with this? Below is the bulk insert I am using

BULK INSERT CUSTOMER_DEALER FROM '\\test\customer_dealer.txt' WITH (MAXERRORS=0, FIRSTROW=2,FIELDTERMINATOR = '|');

 

[Geoka]

Seems wrong data in the date field or format

 

[borgkling2003]

But if I use DTS it is fine.