Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Bulk Insert Error While Trying to Access Format File:

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-11-18 : 08:28:09
Shivshankar writes "I am Receiving an Error No 5: Operating System Error Access Denied While Accessing Format File during Bulk Insert
Kindly give some solutions for this
I am accessing a file on my local machine (server)
I tried this also on server from a node machine"

M.E.
Aged Yak Warrior

539 Posts

Posted - 2002-11-18 : 14:34:54
My guess is the account your logged into (or the account your dts service is running is) has no permissions for that file.

Solution : Give it permissions.

-----------------------
SQL isn't just a hobby, It's an addiction
Go to Top of Page
   

- Advertisement -