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 |
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2005-06-03 : 09:54:58
|
HelloIm trying to load a file and gives the errorCould not bulk insert because file 'http://tmachine/XMLFilesWeb/1/1/exclude.csv' could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).Please let me know how i can load a file from http site |
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-06-03 : 10:07:09
|
BCP doesn't handle http.You could use wget from here http://unxutils.sourceforge.net/ as part of a batch to grab the file first.DamianIta erat quando hic adveni. |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2005-06-03 : 10:09:27
|
Is there any other way to load the file other than bcpI tried the link you sent and it says "page cannot be opened" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-06-03 : 10:14:03
|
Link works for me.There are many ways to load data other than bcp. You could write your own code to do it. Or you could wget the file and BCP It's basically up to you..DamianIta erat quando hic adveni. |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2005-06-03 : 11:10:03
|
Do you think DTS will work |
|
|
X002548
Not Just a Number
15586 Posts |
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2005-06-03 : 11:26:01
|
can you tell about wget and how i can use it |
|
|
|
|
|