BULK INSERT could not be opened. Operating system error code 5(拒绝访问。).

[wihelm]

如题，代码如下：
BULK INSERT Calendar
from 'D:\WileyCompanion'
with
(fieldterminator=' ',
FIRSTROW =2)

文件截图：


sql server服务属性：


报错：
Msg 4861, Level 16, State 1, Line 1
Cannot bulk load because the file "D:\WileyCompanion" could not be opened. Operating system error code 5(拒绝访问。).

[二月十六]

文件名写了吗？WileyCompanion这个是路径吧

[wihelm]

引用 1 楼 二月十六 的回复:

文件名写了吗？WileyCompanion这个是路径吧

确实，不过还是报错：
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 2, column 2 (ISO).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 3, column 2 (ISO).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 4, column 2 (ISO).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 5, column 2 (ISO).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 6, column 2 (ISO).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 7, column 2 (ISO).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 8, column 2 (ISO).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 9, column 2 (ISO).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 10, column 2 (ISO).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 11, column 2 (ISO).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 12, column 2 (ISO).
Msg 4865, Level 16, State 1, Line 1
Cannot bulk load because the maximum number of errors (10) was exceeded.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

文件：

[wihelm]

引用 1 楼 二月十六 的回复:

文件名写了吗？WileyCompanion这个是路径吧

https://pan.baidu.com/s/1zvdfcyTDrxc6jBWZ2b1SCw

[二月十六]

表结构什么样的？

[wihelm]

引用 4 楼 二月十六 的回复:

表结构什么样的？

[wihelm]

引用 4 楼 二月十六 的回复:

表结构什么样的？

CREATE TABLE Calendar (
Date date NOT NULL,
ISO varchar(10) NOT NULL,
datenum int NOT NULL,
DOW char(3) NOT NULL,
DOWint smallint NOT NULL,
Year smallint NOT NULL,
Month smallint NOT NULL,
DOM smallint NOT NULL,
MonthAbbr char(3) NOT NULL,
DOY smallint NOT NULL,
Mondays smallint NOT NULL,
Tuesdays smallint NOT NULL,
Wednesdays smallint NOT NULL,
Thursdays smallint NOT NULL,
Fridays smallint NOT NULL,
Saturdays smallint NOT NULL,
Sundays smallint NOT NULL,
NumHolidays int NOT NULL,
HolidayName varchar(255) NULL,
HolidayType varchar(9) NULL,
hol_National varchar(255) NULL,
hol_Minor varchar(255) NULL,
hol_Christian varchar(255) NULL,
hol_Jewish varchar(255) NULL,
hol_Muslim varchar(255) NULL,
hol_Chinese varchar(255) NULL,
hol_Other varchar(255) NULL
) ;

[吉普赛的歌]

USE tempdb
GO
IF OBJECT_ID('Calendar') IS NOT NULL DROP TABLE Calendar
GO
CREATE TABLE Calendar (
Date date NOT NULL,
ISO varchar(MAX) NOT NULL,
datenum int NOT NULL,
DOW char(3) NOT NULL,
DOWint smallint NOT NULL,
Year smallint NOT NULL,
Month smallint NOT NULL,
DOM smallint NOT NULL,
MonthAbbr char(3) NOT NULL,
DOY smallint NOT NULL,
Mondays smallint NOT NULL,
Tuesdays smallint NOT NULL,
Wednesdays smallint NOT NULL,
Thursdays smallint NOT NULL,
Fridays smallint NOT NULL,
Saturdays smallint NOT NULL,
Sundays smallint NOT NULL,
NumHolidays int NOT NULL,
HolidayName varchar(255) NULL,
HolidayType varchar(9) NULL,
hol_National varchar(255) NULL,
hol_Minor varchar(255) NULL,
hol_Christian varchar(255) NULL,
hol_Jewish varchar(255) NULL,
hol_Muslim varchar(255) NULL,
hol_Chinese varchar(255) NULL,
hol_Other varchar(255) NULL
) ;
GO

BULK INSERT Calendar
from 'd:\calendar.txt'
with
(FIRSTROW =2)

[二月十六]

引用 6 楼 wihelm 的回复:

[quote=引用 4 楼 二月十六 的回复:] 表结构什么样的？

CREATE TABLE Calendar ( Date date NOT NULL, ISO varchar(10) NOT NULL, datenum int NOT NULL, DOW char(3) NOT NULL, DOWint smallint NOT NULL, Year smallint NOT NULL, Month smallint NOT NULL, DOM smallint NOT NULL, MonthAbbr char(3) NOT NULL, DOY smallint NOT NULL, Mondays smallint NOT NULL, Tuesdays smallint NOT NULL, Wednesdays smallint NOT NULL, Thursdays smallint NOT NULL, Fridays smallint NOT NULL, Saturdays smallint NOT NULL, Sundays smallint NOT NULL, NumHolidays int NOT NULL, HolidayName varchar(255) NULL, HolidayType varchar(9) NULL, hol_National varchar(255) NULL, hol_Minor varchar(255) NULL, hol_Christian varchar(255) NULL, hol_Jewish varchar(255) NULL, hol_Muslim varchar(255) NULL, hol_Chinese varchar(255) NULL, hol_Other varchar(255) NULL ) ;[/quote] 测试着没啥问题啊……

[吉普赛的歌]

另外， 如果你实在搞不定， 建议用导入导出向导， 傻瓜化操作， 可以预览。 我在不修改任何关键配置（分隔符按默认设置）的情况下， 也能导入。

[二月十六]

试试这样：

BULK INSERT Calendar
FROM 'D:\WileyCompanion\calendar.txt'
WITH
(
    FIRSTROW = 2
);