both the format file and delimited files are in BISMILLAH
database is on another machine (BISMILLAHSERVER)
bulk directory is shared and full control for everyone
i can access (using windows explorer or start->run)the '\\BISMILLAH\bulk\format.txt' file from all other machines on the network.
when i access the file using windows explorer or start->run, windows 2000 audting on BISMILLAH shows success.
but when when i run the script auditing is not showing either success or failure. i think that means sqlserver is not even requesting for the file.
the error message i got is like follows:
Server: Msg 4861, Level 16, State 1, Line 41
Could not bulk insert because file '\\BISMILLAH\bulk\format.txt' could not be opened.
Operating system error code 5(Access is denied.).
even when i run the script with a non existing file on BISMILLAH the same error message comes.
think u got an idea about the situation.
waiting for ur reply.
regards
renjith