Issue
I am using Docker's MSSQL because I'm on Ubuntu 22.04.
In the terminal,
cat @filepath
where @filepath
is the absolute file path, works.
So the file path exists, and I have file rights (don't need to sudo)
How can I solve this? I am not too sure about how to use docker, but when I connected to my docker's MSSQL, my server was localhost, 1433
Solution
You cannot access your local files from Docker. This is what you should do:
docker cp @FILEPATH @CONTAINER:/
from there,
bulk insert your_table_name
from '/';
or whatever your bulk insert statement, would work
Answered By - sirj Answer Checked By - Marilyn (WPSolving Volunteer)