Hi - I'm receiving an error in a SQL Server 2000 Stored Procedure using Bulk Insert.
Here's the error:
"Could not bulk insert because file '\\server\<path>\file.txt'
could not be opened. Operating system error code 5(Access is denied.)."
This has worked for several years, and it appears that there were some recent changes made that is causing this error. If I log into the database server, I can get to the file path in question, so even though the message says "Access is denied" I'm not convinced that is the issue.
Has anyone seen this before?
BULK INSERT ProcedureName
FIRSTROW = 2,
DATAFILETYPE = 'char',
FIELDTERMINATOR = '\t',
ROWTERMINATOR = '\n',
MAXERRORS = 1