I am facing some issue with running the Bulk Insert script. Here is the detailed information. I am making an installer which will run on exchange server. This server may have the sql server on another machine on network. So what I am doing is, in my installer I am creating one Shared Folder and Replace that path in the sql script. and than execute the script. See below example.
-- FIRSTROW = 2,
FIELDTERMINATOR = '`~', ROWTERMINATOR = '\n'
Here MYEXCHANGEMACHINE is my exchange server machine and DBScripts is my Shared Folder.
But while I am running this script, I am getting following error. **Cannot bulk load because the file "\\DT424\DBScripts\Accounts.txt" could not be opened. Operating system error code 5(Access is denied.).** I searched a lot on google but no luck.. Any idea or any other alternate solution?