Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 BULK INSERT

Author  Topic 

skak
Starting Member

4 Posts

Posted - 2001-12-26 : 15:33:56
Hello:

I was testing out BULK INSERT to Load a Text file (Refer: Item ID:3207 by Garth - 3/19/2001)

when I was executing the procedure as below:
EXEC ps_StudentList_Import "D:\temp\txtfile1.txt",1,2

I was getting following SQL error message:

Server: Msg 4860, Level 16, State 1, Line 1
Could not bulk insert. File 'D:\temp\txtfile1.txt' does not exist.

My id has sysadmin permissions, the file exists on d:\temp\ ... I don't understand why is is not executing the procedure. I was trying to do BULK INSERT on a remote SQL server 7. But when I tried to BULK INSERT into my local SQL server I was able to successfuly do BULK INSERT. Pls. help me out here .... thanks, Sri

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2001-12-26 : 15:40:23
WHERE is your text file? Is it on your local (client's) D drive, or on the SERVER's D Drive. I believe it needs to be on the Server. Books Online says this:

quote:
data_file must specify a valid path from the server on which SQL Server is running. If data_file is a remote file, specify the UNC name.


Then, the next question is this... Do you have the proper file system priveleges?

By the way, what SQLTeam stored procedure are you talking about?



--------------------------------------------------------------
1000 Posts, Here I come! I wonder what my new title will be...

Edited by - AjarnMark on 12/26/2001 15:40:40
Go to Top of Page
   

- Advertisement -