Bulk Insert Problem

29 Jun 2006 8:44 PM

hedgracer

I am trying to do a bulk insert with the following statement:

BULK INSERT dbo.Rand_By_Day from
'C:\Test\Randfinal.txt'

I get the following error:

Msg 4861, Level 16, State 1, Line 3
Cannot bulk load because the file "C:\Test\Randfinal.txt" could not be
opened. Operating system error code 3(The system cannot find the path
specified.).

Can anyone give me an idea why this error is happening? Any help in
advance is appreciated. Thanks.

Dave Christman

29 Jun 2006 9:35 PM

Roy Harvey

BULK INSERT is running on the server. If "C:\Test\Randfinal.txt" is
not on the server it will not be found.

Roy Harvey
Beacon Falls, CT

Show quote

On 29 Jun 2006 13:44:42 -0700, "hedgracer" <d.christ***@sbcglobal.net>
wrote:

>I am trying to do a bulk insert with the following statement:
>
>BULK INSERT dbo.Rand_By_Day from
>'C:\Test\Randfinal.txt'
>
>I get the following error:
>
>Msg 4861, Level 16, State 1, Line 3
>Cannot bulk load because the file "C:\Test\Randfinal.txt" could not be
>opened. Operating system error code 3(The system cannot find the path
>specified.).
>
>Can anyone give me an idea why this error is happening? Any help in
>advance is appreciated. Thanks.
>
>Dave Christman