Re: Could not Bulk insert beacuse file could not be opened

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 16:58:01 -0500

It this file open by any chance? Does the SQL Server agent account have
rights to access this file?
"MMSqlserver" <sqlservermn@discussions.microsoft.com> wrote in message
news:AD0F8466-F5F9-4043-BFE3-CF8BC4D9D021@microsoft.com...
>I am trying to insert data into a table from a text file using bulk insert
> .it works fine on localhost but gives the following error when i run it on
> a
> network.
>
> "Could not bulk insert because file 'E:\far\farextracts\DEGREE.txt' could
> not be opened. Operating system error code 5(Access is denied.)."
>
> any Suggestions or Solutions....
>
> Thanks

Relevant Pages

  • Win2k and SQL2k security
    ... Does anyone know a url to a white paper that explains what ... rights the Sql Server Agent needs in order to create ... operating system and Active Script jobs not belonging to ... rights in order to run these types of jobs. ...
    (microsoft.public.win2000.security)
  • Re: Job Failing if shceduled from DTS
    ... you need to use the full path in the DTS. ... If it is logging in to local machine it does not have access to any network ... available to the SQL Server Agent account. ...
    (microsoft.public.sqlserver.programming)
  • Re: Dynamic Filtering, a further question
    ... "SUser_SName will resolve to account that the SQL Server agent runs under. ... For a push, its the SQL Server agent account on the publisher, for a pull ... the SQL Server agent account on the Subscriber." ...
    (microsoft.public.sqlserver.replication)
  • Re: Win2k and SQL2k security
    ... think complete local admin rights would be necessary, ... >> Does anyone know a url to a white paper that explains what ... >> rights the Sql Server Agent needs in order to create ... >> operating system and Active Script jobs not belonging to ...
    (microsoft.public.win2000.security)
  • Re: SQL Server Agent Credentials
    ... > Check the credentials of the SQL Server Agent Account. ...
    (microsoft.public.sqlserver.server)