BCP in 出现的错误,帮忙各
语句如下:(未用格式文件 .fmt )
bcp longjec.dbo.base_prod in .\bcp_data\base_prod.txt -S192.168.0.234 -Usa -Psa -c -t "`` " -r "@@ " -e .\bcp_err\base_prod.log
不同表的出错信息:
longjec.dbo.base_prod:
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]数值超出范围
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
longjec.dbo.certificate:
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值
longjec.dbo.member_login:
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值
longjec.dbo.message_from:
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]数值超出范围
longjec.dbo.message_to:
Error = [Microsoft][ODBC SQL Server Driver]数值超出范围
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值
-------------------------------------------------------------------
提问:
(1)大家看看上面不同的错误需要加啥参数?以下附BCP语法
-------------------------------------------------------------------
用法: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n native type] [-c character type] [-w wide character type]
[-N keep non-text native] [-V file format version] [-q quoted identifier]
[-C code page specifier] [-t field terminator] [-r row terminator]
[-i inputfile] [-o outfile] [-a packetsize]
[-S server name] [-U username] [-P password]
[-T trusted connection] [-v version] [-R regional enable]
[-k keep null values] [-E keep identity values]
[-h "load hints "]
bcp longjec.dbo.base_prod in .\bcp_data\base_prod.txt -S192.168.0.234 -Usa -Psa -c -t "`` " -r "@@ " -e .\bcp_err\base_prod.log
不同表的出错信息:
longjec.dbo.base_prod:
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]数值超出范围
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
longjec.dbo.certificate:
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值
longjec.dbo.member_login:
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值
longjec.dbo.message_from:
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值
SQLState = 22008, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]无效的数据格式
SQLState = 22003, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]数值超出范围
longjec.dbo.message_to:
Error = [Microsoft][ODBC SQL Server Driver]数值超出范围
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值
-------------------------------------------------------------------
提问:
(1)大家看看上面不同的错误需要加啥参数?以下附BCP语法
-------------------------------------------------------------------
用法: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n native type] [-c character type] [-w wide character type]
[-N keep non-text native] [-V file format version] [-q quoted identifier]
[-C code page specifier] [-t field terminator] [-r row terminator]
[-i inputfile] [-o outfile] [-a packetsize]
[-S server name] [-U username] [-P password]
[-T trusted connection] [-v version] [-R regional enable]
[-k keep null values] [-E keep identity values]
[-h "load hints "]
作者: waymar 发布时间: 2007-01-29
顶死
作者: waymar 发布时间: 2007-01-29
sql server 不熟悉,只能顶
作者: aiirii 发布时间: 2007-01-29
哇,搞那么复杂干嘛,加一个-c参数就可以了.-t代表字段之间的分割符. 你是不是表和数据的列数对不上.
作者: tiantian23256 发布时间: 2011-06-01