SQL Server Developer >> mismatch error when bulk inserting
Hi Folks,
I'm working on a WIN XP SP2 station with SQL2K SPMax (3 or 5 ?)
I'm bulk inserting right thousand of lines in my db but the third one
below generate error 4864. That's the 2003-29-12 value that seems to be
in charge for this problem.
SQL Server Developer >> mismatch error when bulk inserting
Weird. I always use the "ccyy-mm-dd hh:mm:ss.ttt" datetime format when
importing from non-typed sources so I've never encountered such a problem.
SQL Server Developer >> mismatch error when bulk inserting
Don't know.
I'm merely a newbie to SQL2K arcanes, but french environment/language
and linux file format were maybe too much for bulk insert mechanics.
Anyway, I've found much posts about problems related to datetime and
bulk insert on this forum, so there must be somehting rotten in the
bulk insert kingdom.