SQL Server中的大容量复制问题8 [英] Bulk copy issue 8in SQL server

问题描述

嗨

当我尝试使用以下脚本

重新创建时，出现以下错误.

bcp -a Item_Details输出C:\ DB \ 1.dat -n-用户名-PWD

警告:数据包大小必须在512到65535之间-默认为4096.
bcp:未知选项1
用法:bcp {dbtable |查询}出|查询|格式}数据文件
[-m maxerrors] [-f格式文件] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]

你能帮忙解决这个问题吗?

谢谢，
阿米特

我尝试过的事情:

嗨

当我尝试使用以下脚本

重新创建时，出现以下错误.

bcp -a Item_Details输出C:\ DB \ 1.dat -n-用户名-PWD

警告:数据包大小必须在512到65535之间-默认为4096.
bcp:未知选项1
用法:bcp {dbtable |查询}出|查询|格式}数据文件
[-m maxerrors] [-f格式文件] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]

你能帮忙解决这个问题吗?

谢谢，
我猜您到out文件的路径实际上不是C:\DB\1.dat，而是其他带有空格的东西.您必须将此类路径括在"中:例如"C:\Some Folder\Some File.dat".

Hi

When I am trying to create back using below script

I am getting below error.

bcp -a Item_Details out C:\DB\1.dat -n -username -PWD

Warning: Packetsize size must be between 512 and 65535 -- defaulting to 4096.
bcp: unknown option 1
usage: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]

could you please help to fix this.

Thanks,
amit

What I have tried:

Hi

When I am trying to create back using below script

I am getting below error.

bcp -a Item_Details out C:\DB\1.dat -n -username -PWD

Warning: Packetsize size must be between 512 and 65535 -- defaulting to 4096.
bcp: unknown option 1
usage: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]

could you please help to fix this.

Thanks,
amit

解决方案

I guess that your path to the out file is actually not C:\DB\1.dat, but something else with a space in it. You must enclose such paths in "": e.g. "C:\Some Folder\Some File.dat".

这篇关于SQL Server中的大容量复制问题8的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！