Import from HTTP source 1

[travisbrown]

Is there a way to import a flat file into SQL Server from an HTTP source throught DTS?

There is a file to which I don't have lan or FTP access. I'm currently downloading it manually from an http source, moulding, and inserting into the db.

My alternative is using vb or vbs to create an xml stream and creating a local file, but then I'd have to learn stuff.

 

[mrdenny]

Google for a program called http_get.exe. You run it like this.

http_get.exe [URL unfurl="true"]http://www.domain.com/folder/file.txt[/URL] > c:\file.txt

It will download the file and save to to the local disk from a command line. Then you can process it as normal.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[travisbrown]

I'm a little restricted as to what I can run on the server I need this for. I'll run it by the server admin.

Thanks.