还是换行符的错

来源:互联网 时间:1970-01-01

bcp rls..client_ref_temp in c:/clientdata.txt -Snewcredit -Usa -P111111 -t "|" -r -c -Jcp850 报告说:CSLIB Message: - L0/O0/S0/N24/1/0:
cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.
昨天侥幸发现自己没有加换行符 报告说Unexpected EOF encountered in BCP data-file.还以为找到根本原因了呢,没料到今天还是报错。。。还好还好,在朝曦帮忙之下,把他解决了。原因是 clientdata.txt的换行符是/r/n,而bcp默认的是/n,所以报错了,解决办法就是加上 -r "/r/n".



相关阅读:
Top