我使用格式如下:
EXEC master..xp_cmdshell 'bcp SERP.dbo.IOData in C:/200410/07.txt -fc:/200410/iodata.txt -Usa -P'
系统报错:
Error = [Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值
文本格式为:
'02','1','20041007','000330','0812','A0001'
'02','5','20041007','003105','0812','A0002'
'01','6','20041007','003415','0447','A0002'
'01','6','20041007','003417','0239','A0002'
'01','6','20041007','004422','0799','A0002'
'02','1','20041007','011803','0005','A0001'
格式文件为:
8.0
6
1 SQLCHAR 1 2 "," 1 Door ""
2 SQLCHAR 1 1 ","