Timeline for How to allow remote MSSQL user to bulk insert my local txt file?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 25, 2022 at 18:08 | vote | accept | Hrvoje T | ||
| May 25, 2022 at 0:17 | answer | added | J.D. | timeline score: 4 | |
| May 24, 2022 at 23:12 | history | edited | Hrvoje T | CC BY-SA 4.0 |
edited title
|
| May 24, 2022 at 23:02 | comment | added | Hrvoje T | J.D. that could work too, but I wrote the code like this, to bulk insert from a store procedure and it worked fine localy. Now I deployed my code and have trouble with remote db user accessing my text file. | |
| May 24, 2022 at 23:00 | comment | added | Hrvoje T | I am calling a store procedure from Java. This store procedure uses bulk insert from my local txt file to a table in remote db. | |
| May 24, 2022 at 22:59 | comment | added | J.D. | Why not have the Java app bulk insert into your database after reading from the file itself? | |
| May 24, 2022 at 22:54 | comment | added | mustaccio |
A remote SQL Server has no way of reading a file on your local PC. Try bcp.
|
|
| May 24, 2022 at 22:38 | history | asked | Hrvoje T | CC BY-SA 4.0 |