将文件加载到SQL Server时出错 - 批量加载 [英] Error loading file into SQL server - bulk load

问题描述

我必须通过SP将xml文件加载到sql server表中，但是它给出了以下错误：

Hi,

I have to load an xml file into sql server table through SP but its giving below error:

database driver error...
CMN_1022 [Microsoft SQL Server Native Client 11.0: Cannot bulk load because the file "\\tdc2fil001\ST_MISC_INFA_SHARED\RTLF\SrcFiles\Netsol_accounts_20190807.xml" could not be opened. Operating system error code 5(failed to retrieve text for this error. Reason: 15105).
SQL State: 42000 Native Error: 50000
State: 1 Severity: 16
SQL Server Message: Cannot bulk load because the file "\\tdc2fil001\ST_MISC_INFA_SHARED\RTLF\SrcFiles\Netsol_accounts_20190807.xml" could not be opened. Operating system error code 5(failed to retrieve text for this error. Reason: 15105).

我们需要设置任何设置批量加载更改？



谢谢，

Aditya



我尝试过：

Is there any setting that we need to change for bulk load ?

Thanks ,
Aditya

What I have tried:

Is there any setting that we need to change for bulk load ?

推荐答案

检查文件是否存在，并确保SQL可以访问该文件以及用户运行的用户的相应权限。错误消息非常明确：

Check that the file exists, and make sure that SQL has access to the file along with the appropriate permissions for the user SQL is runnign under. The error message is pretty clear:

Cannot bulk load because the file "\\tdc2fil001\ST_MISC_INFA_SHARED\RTLF\SrcFiles\Netsol_accounts_20190807.xml" could not be opened.

由于我们无法访问您的网络或文件系统，因此我们无法为您做任何事情。

Since we do not have any access to your network or file system, we can;t do anything about that for you.

这篇关于将文件加载到SQL Server时出错 - 批量加载的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！