Little stumped with this problem trying to do a bulk insert into a table and it was working fine for a while and suddenly started giving this:
Cannot bulk load because the file 'file.txt' could not be opened. Operating system error code 5(Access is denied.)
I checked the SQL Service account to have permissions to this file.
With some testings, I found that if I run the bulk stmt. as a "sa" user, it works ok, however, when I run it as a windows domain user(which has all the permissions on the file), it fails with the error.
Any ideas why it this is so?