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:44:48
|
| 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:55
|
| Do not post the same question twice:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27583[/url]Tara |
 |
|
|
|
|
|
BULK INSERT from another server