Is it possible to grab a file using T-SQL via HTTP? I'm familiar with grabbing a file via FTP using a script and xp_cmdshell. I want to do the same thing except the file is only available via HTTP.
My guess is that it's not possible. If not, what are some alternatives? wget for Windows?
My goal is to get the file onto the SQL server then BULK INSERT it into a table. Like I said, I can do this with FTP without an issue.
Edit: Server version is only SQL 2000.