无法从文件批量加载。 [英] Could not bulk load from a file.
本文介绍了无法从文件批量加载。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的任务是在远程服务器上,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.
这篇关于无法从文件批量加载。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文