I have been using BULK INSERT to get the data from text file with Sql server 2k and SP3.
Recently we have replaced our server, so we installed fresh sql server 2k with SP4.
All of sudden our it stopped working. It is giving the error following error message
"Could not bulk insert because file '\\server\<path>\file.txt' could not be opened. Operating system error code 5(Access is denied.)."
I made srue about
1. SQL Server service account is under domain accounts
2. Shared folder has been given rights
3. Login is added to Bulk insert administrator
Please post your thoughts.....thanks.