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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment