SQl导入BCP错误

Question

我正在使用带dat的BCP命令将表导入到sql server，tables.Here的xml文件是我的命令：

-bcp database_name.dbo.TasksXml in task_xml.dat -T -f
task_xml.xml

但是我收到的BCP copy failed.The错误是：-

Starting copy...
1000 rows sent to SQL Server. Total sent: 1000
1000 rows sent to SQL Server. Total sent: 2000
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right       truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right truncation
1000 rows sent to SQL Server. Total sent: 3000
1000 rows sent to SQL Server. Total sent: 4000
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right truncation
1000 rows sent to SQL Server. Total sent: 5000
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right  truncation
1000 rows sent to SQL Server. Total sent: 6000
1000 rows sent to SQL Server. Total sent: 7000
1000 rows sent to SQL Server. Total sent: 8000
1000 rows sent to SQL Server. Total sent: 9000
1000 rows sent to SQL Server. Total sent: 10000
1000 rows sent to SQL Server. Total sent: 11000
1000 rows sent to SQL Server. Total sent: 12000
1000 rows sent to SQL Server. Total sent: 13000
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right truncation
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right truncation
1000 rows sent to SQL Server. Total sent: 14000
1000 rows sent to SQL Server. Total sent: 15000
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right truncation
1000 rows sent to SQL Server. Total sent: 16000
1000 rows sent to SQL Server. Total sent: 17000
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right truncation 
1000 rows sent to SQL Server. Total sent: 18000
   1000 rows sent to SQL Server. Total sent: 19000
   SQLState = 22001, NativeError = 0
   Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right   truncation
    1000 rows sent to SQL Server. Total sent: 20000
    1000 rows sent to SQL Server. Total sent: 21000
    SQLState = 22001, NativeError = 0
    Error = [Microsoft][ODBC Driver 11 for SQL Server]String data, right  truncation
    SQLState = S1000, NativeError = 0
    Error = [Microsoft][ODBC Driver 11 for SQL Server]Text column data    incomplete
    SQLState = 37000, NativeError = 9420 
    Error = [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]XML parsing: line
    1, character 1725, illegal xml character

failed.How中的BCP copy我能解决这个错误吗？谢谢

Answer 1

检查目标表的database_name.dbo.TasksXml列是否足以处理数据，理想情况下，它们将与提取数据的原始位置相匹配。