Ошибка импорта SQl BCP

Я работаю над импортом таблиц на сервер sql с помощью команды BCP с таблицами dat и xml. Вот моя команда:

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

Но копия BCP не удалась. Я получаю сообщение об ошибке: -

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

Ошибка копирования BCP. Как устранить эту ошибку? Спасибо


sql-server bcp
person Youv    schedule 18.11.2015    source источник

Ответы (1)


arrow_upward
-1
arrow_downward

проверьте, что столбцы таблицы назначения database_name.dbo.TasksXml подходят для обработки ваших данных, в идеале они должны соответствовать исходному местоположению, из которого вы извлекли данные.

person Edward Comeau    schedule 18.11.2015