Unable to execute ‘BULK INSERT‘task importing data from a flat file on a file share (\\) into a SQL Server database on a sql server instance. I amgetting an access denied error on the flat file which exists on a file share.
However, when Iuse the sa account, I was able to bulk insert. The user has all the privileges needed to do a bulk insert.
Only the ‘sa’ login can execute the BULK INSERT task. No other login can execute this command without getting access denied error.
The SQL Server service is running under a domain account