Load JSON file from network location
-
Hello, I am trying to load a json file from network location into a table on sql server 2016. The domain account has access to both the file on network as well as the database. I keep receiving this message:
Cannot bulk load because the file "\\\loaddata.json" could not be opened. Operating system error code 5(Access is denied.).
In the above error message, does the user not have access to file or to perform the "bulk load" action? Much appreciated!
-
Hello, I am trying to load a json file from network location into a table on sql server 2016. The domain account has access to both the file on network as well as the database. I keep receiving this message:
Cannot bulk load because the file "\\\loaddata.json" could not be opened. Operating system error code 5(Access is denied.).
In the above error message, does the user not have access to file or to perform the "bulk load" action? Much appreciated!
Also, I am using Windows authentication for SQL server, and this same user also has access to the share on network.
-
Hello, I am trying to load a json file from network location into a table on sql server 2016. The domain account has access to both the file on network as well as the database. I keep receiving this message:
Cannot bulk load because the file "\\\loaddata.json" could not be opened. Operating system error code 5(Access is denied.).
In the above error message, does the user not have access to file or to perform the "bulk load" action? Much appreciated!
I think it means that the SQL Server identity (not the user) does not have access to the network drive. I always move the file to the SQL Server server or loaded it via c#. Loading via c# I would put into a datatable EXACTLY matching the destination table and use BULKCOPY [^] to insert it into the destination
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP