April 16, 2009 at 2:34 am
Hi guys,
In a nutshell, I was wondering if it is possible to call a webservice from within a stored proc. The web service will give me my SOAP response (with XSD schema) and I want to be able to convert that into a table and manipulate the data.
I've done plenty of XML manipulation from a local file on the server straight into a db table but nothing with web services. Any help you can give will be greatly appreciated!
Cheers!
April 28, 2009 at 10:35 am
Is CLR an option in your environment? if so, check out: http://davidhayden.com/blog/dave/archive/2006/04/25/2924.aspx and see if that helps.
May 1, 2009 at 2:45 am
Hi ghollis,
It's our server so yes, CLR would be an option. That's a new area for me though in the realms of SQL Server but it does look interesting.
Are we basically talking about a DB side call to an external app (e.g. web service) with the results returned straight back to the server?
May 1, 2009 at 8:45 am
Yes,
That is what I was thinking and the blog from David does a good job of demonstrating the web service call. Another option would be an SSIS package thast is called from the Stored Proc, but that requires some hefty rights (See http://www.codeproject.com/KB/database/Call_SSIS_from_SP.aspx form more info).
Gary
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply