How to allow remote MSSQL user to bulk insert my local txt file?
0
votes
1
answer
1648
views
I have a txt file on my local PC. I run localy Java app which connects to remote MSSQL. Now I need to bulk insert from that text file into my database table.
However, SQL login can't read my file. I get:
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot
> bulk load because the file "D:/My_Files/my_file.txt" could not be opened.
> Operating system error code 21(The device is not ready.)
I set permissions on My_Files folder for 'Everyone'. I can't create a Windows user with the same name like SQL login because it is too long for Windows user. Is there a solution?
Asked by Hrvoje T
(163 rep)
May 24, 2022, 10:38 PM
Last activity: May 25, 2022, 12:17 AM
Last activity: May 25, 2022, 12:17 AM