Friday, February 24, 2012

Could not Bulk insert beacuse file could not be opened

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
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

No comments:

Post a Comment