level 1
邂逅的守望
楼主
BULK INSERT [test].dbo.BARCODE_DATA_tmp FROM '\\192.168.2.111\CDWriter\BARCODE_DATA.txt'
WITH (
FORMATFILE='\\192.168.2.111\CDWriter\XMLFile1.xml',
FIELDTERMINATOR = '|',
ROWTERMINATOR = '\n'
)
SQL查询分析器提示：
消息 4820，级别 16，状态 1，第 1 行
Could not bulk insert. Unknown version of format file '\\192.168.2.111\CDWriter\XMLFile1.xml'.
求大神指点~~~
2014年06月05日 03点06分
1
WITH (
FORMATFILE='\\192.168.2.111\CDWriter\XMLFile1.xml',
FIELDTERMINATOR = '|',
ROWTERMINATOR = '\n'
)
SQL查询分析器提示：
消息 4820，级别 16，状态 1，第 1 行
Could not bulk insert. Unknown version of format file '\\192.168.2.111\CDWriter\XMLFile1.xml'.
求大神指点~~~