sql-server - 为什么在 MS SQL Server 中批量插入时收到 "XML parsing: line 2, character 0, incorrect document syntax"

Question

我正在使用 FMT 格式文件对表进行批量插入，但出现以下错误:

XML parsing: line 2, character 0, incorrect document syntax

这是我的代码

BULK INSERT [DM_Flux].[dbo].[Stage] FROM 'C:\temp\data.dat'
WITH (FORMATFILE = 'C:\temp\FormatBcp.fmt')

这是格式文件(标准格式文件，不是 XML):

10.0
5
1   SQLCHAR 0   2   ""  1   Id  ""
2   SQLCHAR 0   40  ""  2   Name    ""
3   SQLCHAR 0   50  ""  3   Street  ""
4   SQLCHAR 0   8   ""  4   StreetNo    ""
5   SQLCHAR 0   300 "\r\n"  7   BulkData    ""

为什么我会收到 XML 错误？

Answer 1

还有一点，以防万一其他人遇到这个问题......

如果您确定文件是 ANSI 但仍然收到此错误，请检查格式文件的第一行(版本号)。版本号必须与您的 SQL 版本号匹配(或者是旧版本号)。

MSDN reference :

The version of the bcp utility (Bcp.exe) used to read a format file must be the same as, or a later version than was used to create the format file. For example, SQL Server 2008 bcp can read a version 9.0 format file, which is generated by SQL Server 2005 bcp, but SQL Server 2005 bcp cannot read a version 10.0 format file, which is generated by SQL Server 2008 bcp.