sqlserver bulk insert报错Cannot bulk load because the file could not be opened.

参考文档
https://techcommunity.microsoft.com/t5/sql-server-support/sql-bulk-copy-error-8220-operating-system-error-code-5-access-is/ba-p/316231

使用SSMS打开数据库服务器db1，执行如下
BULK INSERT Fileinfo
FROM ‘\netapp2\Dev\files.csv’
WITH
(
FIELDTERMINATOR = ‘|’
);
报错：Cannot bulk load because the file “\netapp2\Dev\files.csv” could not be opened. Operating system error code 5(Access is denied.).

问题分析
1、登录数据库服务器db1，在操作系统界面上可以直接打开\netapp2\Dev\files.csv
2、在SSMS上执行bulk insert语句的用户是user1，而user1有访问\netapp2\Dev\files.csv文件的权限

解决方法
登录netapp2服务器，在cmd窗口执行hostname发现服务器名称是fsprod2，使用\fsprod2\Dev\files.csv替代\netapp2\Dev\files.csv，问题解决