BCP导入txt文本到SQL数据库: 如何跳过自增长表列?
BCP导入txt文本到SQL数据库,服务器有一个日志文件需要入库,格式如下:
1 0.0.0.0 0 0.0.0.0 2008-1-29 19:16:43.132 2008-1-29 19:18:15.123 192.168.1.6 00-E0-A0-05-B8-FA 1 2008-2-3 17:12:26.312
bcp的fmt文件也生成了:
9.0
11
1 SQLCHAR 0 12 "\t" 1 ID ""
2 SQLCHAR 0 12 "\t" 2 GameID ""
3 SQLCHAR 0 100 "\t" 3 GameEdition Chinese_PRC_CI_AS
4 SQLCHAR 0 12 "\t" 4 PlayerArea ""
5 SQLCHAR 0 100 "\t" 5 SDKEdition Chinese_PRC_CI_AS
6 SQLCHAR 0 100 "\t" 6 ConnStartDate Chinese_PRC_CI_AS
7 SQLCHAR 0 100 "\t" 7 ConnEndDate Chinese_PRC_CI_AS
8 SQLCHAR 0 100 "\t" 8 Ip Chinese_PRC_CI_AS
9 SQLCHAR 0 200 "\t" 9 MACAddress Chinese_PRC_CI_AS
10 SQLCHAR 0 20 "\t" 10 Chn Chinese_PRC_CI_AS
11 SQLCHAR 0 100 "\r\n" 11 AddDate
第一个ID为自增长,只读。我想跳过这个表列。按照微软的说法我改了下fmt文件如下:
9.0
10
1 SQLCHAR 0 0 "" 0 ID ""
2 SQLCHAR 0 12 "\t" 2 GameID ""
3 SQLCHAR 0 100 "\t" 3 GameEdition Chinese_PRC_CI_AS
4 SQLCHAR 0 12 "\t" 4 PlayerArea ""
5 SQLCHAR 0 100 "\t" 5 SDKEdition Chinese_PRC_CI_AS
6 SQLCHAR 0 100 "\t" 6 ConnStartDate Chinese_PRC_CI_AS
7 SQLCHAR 0 100 "\t" 7 ConnEndDate Chinese_PRC_CI_AS
8 SQLCHAR 0 100 "\t" 8 Ip Chinese_PRC_CI_AS
9 SQLCHAR 0 200 "\t" 9 MACAddress Chinese_PRC_CI_AS
10 SQLCHAR 0 20 "\t" 10 Chn Chinese_PRC_CI_AS
11 SQLCHAR 0 100 "\r\n" 11 AddDate
运行说主序列不对,奇怪。希望那个高手能解决下这个fmt问题。搜遍CSDN也没有看到答案。