无法从文件批量加载。 [英] Could not bulk load from a file.

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

问题描述

我的任务是在远程服务器上,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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆