Click here to Skip to main content
15,917,875 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
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).


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 ?
Posted
Updated 1-Jun-18 3:51am

1 solution

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.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900