Date Conversion Error

[tyaramis]

Hi All,
We have a problem in Sql Server 7.0 while transferring data from text file to into a smalldatetime field of table. The data in text file has "dd/mm/yyyy" format. When we try to insert data to date field by using bulk copy method, we are getting this error.

"Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 182015, column 1 (TARIH)."

After the row '182015', the date data in text file is begining like this;
"13/03/2002".
Then, the problem has occured!!!!

P.S: We checked the reginol settings, the date setting of system is also "dd/mm/yyyy"

Does anyone has idea about this problem?

Thank u for your interest...

Tolga

 

[Guest_imported]

A column delimiter or end of row character may be corrupting your data ie you have an extra comma in an address field. Try changing the info in the previous column to a date or split the file into two.

 

[harmmeijer]

The language settings of the user that is logged on (running bcp) determines the date format.