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 |
|
funart
Starting Member
9 Posts |
 Posted - 2003-07-08 : 16:45:44
|
| Hi there!I'm trying to do a BULK INSERT on my SQL Server with a file that resides on my webserver (two different locations). I am trying to run this BULK INSERT from a stored procedure, which is called from an ASP page. This does work when I'm running everything on my local machine (both SQL Server and local IIS).When I try this, I get an error along the lines of <file> could not be opened.When I try to send it the url, I get the following: <file> could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.). I still want to keep the files wherever they are, as I don't think I can write these files from my website.Thank you for all and any help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-08 : 16:53:34
|
| From SQL Server Books Online:"BULK INSERT can copy data from a disk (including network, floppy disk, hard disk, and so on). 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 Universal Naming Convention (UNC) name."Tara |
 |
|
|
funart
Starting Member
9 Posts |
Posted - 2003-07-09 : 09:30:18
|
First, I'm sorry for posting the question twice, it was an accident, and I couldn't figure out how to delete it.Next,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 Universal Naming Convention (UNC) name."
this would only be good if the two servers were connected in their own network, but I'm pretty sure mine aren't (I'm finding that out now). So, how else would I be able to reference this file if there is no UNC?Please be advised, that I am new to SQL server, and I apologize if I'm asking obvious questions.Thank you for your help |
|
|
|
|
|
|
|
|
BULK INSERT from another server