Re: bulk insert

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Is the F: drive local for each cluster node, or is it a shared cluster
physical drive resource?


Anthony Thomas


--

"Juan Bautista" <JuanBautista@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CA335F4E-A9C6-4117-A107-53CD1995B21F@xxxxxxxxxxxxxxxx
Thanks for your reply, here is the bulk insert statement, as you could
see there is nothing special in it.

BULK INSERT Users_Table
FROM 'F:\UsersLoad.txt'
WITH (
fieldterminator='|'
rowterminator='\n' )

"Linchi Shea" wrote:

That doesn't sond right. We do bulk insert into clustered SQL instances
all
the time, and if a non-existing file is specified, an error stating
'file
does not exist' is encountered.

It may help if you post you BULK INSERT statement. Something is missing
here.

Linchi

"Juan Bautista" wrote:

We have an clustered sql server 2000 with service pack 4. We are
trying to
import some date using 'bulk insert'. The command ends ok but there is
no
rows inserted on our table. Furthermore if we specifify a data_file
that not
exists the commands end ok with no error message.

The same command and same data_file in our development environment
(sql
server 2000 service pack 4 NOT clustered) works fine and if we specify
a data
file that not exists we receive the corresponding error message.


.