T-SQL Get File Over HTTP?

Question

Is it possible to capture a file using T-SQL over HTTP? I am familiar with capturing a file via FTP using script and xp_cmdshell. I want to do the same, except that the file is only accessible through HTTP.

I guess this is not possible. If not, what are the alternatives? wget for windows?

My goal is to upload the file to the SQL server, then BULK INSERT it to the table. As I said, I can do this with FTP without any problems.

Edit: Server version is SQL 2000 only.

Answer 1

• You can use a VBScript file to replace wget for windows. Found a simple script file on this page .

• SQL Server 2005 , .NET, T-SQL