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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 bcp error

Author  Topic 

cbeganesh
Posting Yak Master

105 Posts

Posted - 2005-06-03 : 09:54:58
Hello

Im 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.


Damian
Ita erat quando hic adveni.
Go to Top of Page

cbeganesh
Posting Yak Master

105 Posts

Posted - 2005-06-03 : 10:09:27
Is there any other way to load the file other than bcp
I tried the link you sent and it says "page cannot be opened"
Go to Top of Page

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..


Damian
Ita erat quando hic adveni.
Go to Top of Page

cbeganesh
Posting Yak Master

105 Posts

Posted - 2005-06-03 : 11:10:03
Do you think DTS will work
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-06-03 : 11:16:54
No

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page

cbeganesh
Posting Yak Master

105 Posts

Posted - 2005-06-03 : 11:26:01
can you tell about wget and how i can use it

Go to Top of Page
   

- Advertisement -