Sample Header Ad - 728x90

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