call a web service from T-SQL in Sql Server 2008

Question

Is there a way to call a HTTP web service from T-SQL (no SQLCLR) in Sql Server 2008? I just need to send information out, I do not need to receive anything into T-SQL.

Thanks.

Answer 1

The Web Service Task should allow you to do that.

http://msdn.microsoft.com/en-us/library/ms140114.aspx
http://msdn.microsoft.com/en-us/library/cc952927(SQL.100).aspx

I'm assuming you are doing this from an "intergration services" package

Answer 2

If you are doing this in a sproc, then you could create a tiny VB program and use

exec sp_cmdshell 'c:\path\myapp.exe'

to call your program. Technically its not CLR embedded in SQL Server right? :)

Answer 3

You can automate the XMLHTTP server object using the Object Automation extended stored procedures.

Example here

I suggest you use the CLR or an SSIS package though.