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.
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,2I was getting following SQL error message:Server: Msg 4860, Level 16, State 1, Line 1Could 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 |
|
|
|
|
|