[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