[thelist] SQL2k: BULK INSERT not failing but also not creating row

Ashok Hariharan listman at hazard0us.org
Mon Nov 25 08:30:01 CST 2002


>Thanks.  Any other ideas?

I remember somebody having a similar problem on SqlTeam.
Apparently 'bulk insert' fails when it encounters a file whose size is
divisible by
the number 4.  Is that the case ?
If so try adding a few spaces at the end of your file....

Additionally instead of testing with a  bulk insert, try using the command
line 'bcp'
utility, which gives more descriptive error messages.

------
Ashok Hariharan
listman(at)hazard0us.org
http://www.unganisha.org
------








More information about the thelist mailing list