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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

4 Posts

Posted - 12/26/2001 :  15:33:56  Show Profile  Reply with Quote

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

SQL Slashing Gunting Master

3246 Posts

Posted - 12/26/2001 :  15:40:23  Show Profile  Visit AjarnMark's Homepage  Reply with Quote
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:

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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000