BCP import data problem, prompting unexpected EOF ~ urgent

wanghun

Start copying ...
SQLState = S1000, NativeError = 0
Error = [Microsoft] [ODBC SQL Server Driver] Unexpected EOF encountered in BCP data file

0 rows copied.
Packet size (bytes): 4096
Clock time (ms): 31

The BCP statement is written like this:
exec master..xp_cmdshell 'bcp "test.abc.inf_TEST001" in "E:\Work\Task\TEST001" -c -r "\n" -SWJP -Usa -Psa'

Which prawn helped me to see what the problem is, I am grateful ~~

我是杀人狂

EXEC master..xp_cmdshell 'bcp "dbname..tablename" in c:\DT.txt -c -Sservername -Usa -Ppassword'

wanghun

Is there anything wrong with my sentence? Already prompted "Start Copying ..."

我是杀人狂

Data file with suffix .txt

wanghun

TO我是杀人狂
The TEST001 file is generated by another program (the file name is like this, without a suffix, and it is in UNIX format). My program task is to import this file into the database.

我是杀人狂

The bcp import format should be the one I wrote above, but I don't know if I can import the UNIX format ...

kxiaper

The landlord does not set a separator
For example, add -t after -c, which means comma separated

wanghun

TOkxiaper
Using your method, there seems to be no problem reading the file, but the following problems appear
Start copying ...
SQLState = 22001, NativeError = 0
Error = [Microsoft] [ODBC SQL Server Driver] string data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft] [ODBC SQL Server Driver] string data, right truncation
SQLState = 22001, NativeError = 0

Please troubleshoot again, is there a problem with my file format or is it something else?

kxiaper

an examination:
1. The number of fields in the inf_TEST001 table may not be enough. It must be the same as the number of comma-separated segments in your data.
2. Field length may be insufficient

wanghun

Haha, thank youkxiaper