bcp在命令行中正确执行，但是在bat文件中报错！

licheer

数据库版本：12.5.0.3
bcp语句：bcp umvc..TEST in D:\test\test\bcp1.bcp -e c:\bcp_error_1.txt -b 1000 -c -t "[email=$$@@$$]$$@@$$[/email]" -r "@#$%" -U umvc -P p9o8i7 -S SYBNM

同一条语句，在开始->运行->cmd中可以正确执行
但是将此语句拷贝到update.bat中执行时，报如下错误：
Starting copy...
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
bcp copy in failed

licheer

修正一下
-t的分隔符是“$$@@$$”
不知道为什么发帖子的时候会被系统改掉

hobbylu

我估计就是分隔符所造成的

licheer

可是它在命令行中是可以正确执行的啊

action929

因为 % 在 bat 里面是特殊字符
你试试 这个语句
bcp umvc..TEST in D:\test\test\bcp1.bcp -e c:\bcp_error_1.txt -b 1000 -c -t "[email=$$@@$$]$$@@$$[/email]" -r "@#$%%" -U umvc -P p9o8i7 -S SYBNM

licheer

果真可以了，谢谢楼上

fgh678

偶也来看看．．．．．．．．．．．．．