mismatch error when bulk inserting  
Author Message
Hakùna





PostPosted: Tue Jul 12 07:34:01 CDT 2005 Top

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.

MAG|FR|68|0000000Q80977|1|2005-28-6|2005|6|200526|28|3|10|119.9|
181.86|19.9|0|2005-11-7||
MAG|FR|68|0000000Z80979|1|2005-28-6|2005|6|200526|28|3|4|312.9|
311.18|114.5|0|2005-11-7||
MAG|FR|68|0000000X81000|1|2003-29-12|2003|12|200401|29|2|0|16.8|
6.415|13.35|0|2005-11-7||

Other lines insert smoothly and quickly.

Any ideas welcome.

Thanks
Georges

SQL Server234  
 
 
ML





PostPosted: Tue Jul 12 07:34:01 CDT 2005 Top

SQL Server Developer >> mismatch error when bulk inserting What about these two ... 6.415|13.35 ... - are they ok?

Providing DDL would also help. A lot.


ML
 
 
gja





PostPosted: Tue Jul 12 07:50:52 CDT 2005 Top

SQL Server Developer >> mismatch error when bulk inserting
Thanks ML for your quick answer (and question) but i found the cure for
this problem :

1) Change the date format from 2003-20-12 to 20031229

=> Cures the 4864 Error for this value but generates another for the
last (empty) zone which was also a datetime. Try to fill it but no
effect.

2) The pipe delimited file comes from Linux Universe and a CR/LF
conversion was (absolutly) necessary.

=> No more 4864 now.

Don't know if we can call it a MS bug/flaw but it was a real pain in my
brain. ;-)

Thanks again.

 
 
ML





PostPosted: Tue Jul 12 09:26:08 CDT 2005 Top

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.


ML
 
 
gja





PostPosted: Tue Jul 12 10:02:03 CDT 2005 Top

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.

GJA