bcp error importing native sql server file

[bluecjh]

SQL SERVER 2000.


bcp "highway.dbo.invoices" in "C:\Documents and Settings\home\My Documents\a1testn.Dat" -n -m"100" -S"HOME-51MUTE0LEJH"

i receive the dos screen errors

sqlState = 22001, NativeError = 0
Error = [microsoft][ODBC SQL SERVER DRIVER] STRING DATA
RIGHT TRUNCATION

I have tried increasing all VARCHAR column sizes on the
receiving table significantly but to no avail.

Can anyone suggest what might be the problem or how
i might be able to circumvent this?

many thanks

BlueCJH

 

[bluecjh]

solved my own problem - importing the wrong table!


BlueCJH