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.

Martin Smith · Accepted Answer · 2010-07-31 20:07:28Z

2

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.

answered Jul 31, 2010 at 20:07

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jeremy · Accepted Answer · 2010-07-30 17:45:00Z

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? :)

answered Jul 30, 2010 at 17:45

Jeremy

4,8582 gold badges23 silver badges24 bronze badges

Comments

del.ave · Accepted Answer · 2013-04-16 11:08:02Z

2

The Web Service Task should allow you to do that.

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

edited Apr 16, 2013 at 11:08

user2022859

answered Jul 30, 2010 at 17:40

del.ave

1,9485 gold badges18 silver badges23 bronze badges

Collectives™ on Stack Overflow

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

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related