无法从文件批量加载。

本文介绍了无法从文件批量加载。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我的任务是在远程服务器上，csv文件也在同一台服务器上。当我的任务运行时，它会抛出以下错误。我该如何修复？ 我收到以下错误。

My task is on remote server and csv file is also in the same server. When my task runs It throws below error. How do I fix? I am getting following errors.

Cannot bulk load because the file "\\networkPath\d$\fileName.extension" could not be opened. Operating system error code 5(Access is denied.).

我尝试过： 我添加并让SqlService帐户完全控制文件夹。

What I have tried: I add and let SqlService account full control over folder.

推荐答案

\ fileName.extension不能操作系统错误代码5（访问被拒绝。）。 \fileName.extension" could not be opened. Operating system error code 5(Access is denied.).

我尝试过： 我添加并让SqlService帐户完全控制文件夹。

What I have tried: I add and let SqlService account full control over folder.

错误信息非常清楚。这不是编程问题但是文件访问问题。我怀疑你试图打开的文件是由另一个应用程序独占打开的。 The error message is pretty clear. This is not a programming issue but a file access issue. I suspect that the file that you are trying to open is exclusive held open by another application.