SQL Server 2000批量插入问题 [英] SQL Server 2000 Bulk Insertion issue
问题描述
你好团队,
运行新的批处理文件(.bat)到批量处理时,我收到以下错误 使用以下BCP命令插入,但我收到以下错误消息。帮帮我 解决 这个问题。
错误消息:
开始复制... SQLState = 22001,NativeError = 0错误= [Microsoft] [ODBC SQL Server驱动程序]字符串数据,右截断。
使用以下bcp命令时 我正在努力完成这项工作:
bcp PatsDB.dbo.Sharepoint在Sharepoint.txt / S USFLMIAD-DB01 / Ucensus_admin / PCA1934 / f Sharepoint.fmt
Table结构:
CREATE TABLE [Sharepoint](
[Scheck] [varchar](6)COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Surl] [varchar](8000)COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
用于批量插入的总记录数-12220
< blockquote>
为
提供的参数 源列
大于(长度)而不是 目的地
s
列宽 所有coulmn.kindly增加coulmn宽度并检查。
https://stackoverflow.com/questions/183488 /什么 - 做最SQL服务器错误字符串数据右截断均值和知识-DO-
块引用>Hello Team,
I am getting the below error while running the new batch file (.bat) to bulk insert using below BCP command but i am getting the below error message. Help me to resolve this issue.
Error Message :
Starting copy... SQLState = 22001, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation.
Using below bcp command when i am trying to run the job :
bcp PatsDB.dbo.Sharepoint in Sharepoint.txt /S USFLMIAD-DB01 /Ucensus_admin /PCA1934 /f Sharepoint.fmt
Table Structure :
CREATE TABLE [Sharepoint] ([Scheck] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Surl] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
Total records count using for bulk insertion -12220
Either the parameter supplied for source column is larger (in length) than
destination
s column width for all coulmn.kindly increase coulmn width and check.
这篇关于SQL Server 2000批量插入问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!