表:
CREATE TABLE [dbo].[XCHG_2003] (
[ID] [bigint] NOT NULL ,
[TABLEID] [int] NOT NULL ,
[ACTIONID] [tinyint] NULL ,
[STATUS] [tinyint] NULL ,
[rowguid] uniqueidentifier ROWGUIDCOL NOT NULL
) ON [PRIMARY]文本文件(unicode编码)
2003,4,,,{9272AD40-5F5F-4B0C-83F4-BE1C574F7404}
2004,4,,,{658D21BD-2C4F-44C6-919B-7C189A7CACEE}
数据是我导出来的,结束用chr(13)+chr(10)我写的插入语名
BULK INSERT Xchg_2003
FROM 'D:\XCHG_2003.txt'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR ='\r\n',
DATAFILETYPE='widechar',
ERRORFILE = 'd:\error.log' ,
firstrow=0,
LASTROW = 3 --KEEPIDENTITY )
执行出错:
Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 1, column 5 (rowguid).估计是第五列,guid的问题,用默认值newid()?
请各位帮忙看看,如果是文本文件在网络中别一台机器上,//机器/d$/XCHG_2003.txt这样行不行
CREATE TABLE [dbo].[XCHG_2003] (
[ID] [bigint] NOT NULL ,
[TABLEID] [int] NOT NULL ,
[ACTIONID] [tinyint] NULL ,
[STATUS] [tinyint] NULL ,
[rowguid] uniqueidentifier ROWGUIDCOL NOT NULL
) ON [PRIMARY]文本文件(unicode编码)
2003,4,,,{9272AD40-5F5F-4B0C-83F4-BE1C574F7404}
2004,4,,,{658D21BD-2C4F-44C6-919B-7C189A7CACEE}
数据是我导出来的,结束用chr(13)+chr(10)我写的插入语名
BULK INSERT Xchg_2003
FROM 'D:\XCHG_2003.txt'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR ='\r\n',
DATAFILETYPE='widechar',
ERRORFILE = 'd:\error.log' ,
firstrow=0,
LASTROW = 3 --KEEPIDENTITY )
执行出错:
Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 1, column 5 (rowguid).估计是第五列,guid的问题,用默认值newid()?
请各位帮忙看看,如果是文本文件在网络中别一台机器上,//机器/d$/XCHG_2003.txt这样行不行
2//机器/d$/xchg_2003.txt 可以 但是你要确认当前登陆的用户有网络的访问权限 不然会报错。