Re: Could not bulk insert

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 04/05/04 

Date: Mon, 5 Apr 2004 14:07:14 +0530

Hi,

This error normally comes when you are not able to access the remote share.

The problem might be the account under which your SQL Server runs, must be
authorized to access
the share on \\Ntp\app\HARRIS .
This will not work if SQL Server runs under the local system account. So
ensure that you start your SQL server using a domain account which has
access to \\Ntp\app\HARRIS share.

Thanks
Hari
MCDBA
"HARRIS ARISTOTELOUS" <harris@glprodata.com> wrote in message
news:187bb01c41ae7$77752530$a101280a@phx.gbl...
> Dear All,
>
> Im trying to execute the follownf command:
> (BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
> FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
>
>
> from Query analyzer and I get the message:
>
> (Server: Msg 4861, Level 16, State 1, Line 1
> Could not bulk insert because
> file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
> opened. Operating system error code 5(error not found).)
>
> what might be the problem:
>
>

Quantcast