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