July 23, 2009 at 7:04 pm
I have a project in hand to call a web service and store its results in a table. I am doing a feasibility study and exploring the different ways to implement this. I have come across SSIS as a way to go. Are there any more suggestions of how I can achieve this?
Can some one please post me few examples of how this can be done.
Also I have an issue with the XML that I get back from the webservice call. THE XML has namespaces and attributes in it, which I need to remove before I can parse it in TSQL. Please help me with a way to strip the namespaces and attributes from the XML.
July 23, 2009 at 9:15 pm
TSQL works inside the SQL Server. If you need to call a service outside of SQL server, you need to implement a CLR assembly to do this.
July 23, 2009 at 9:47 pm
Thanks for your response.
What are the advantages/disadvantages of CLR SPs as against the SSIS approach.AS I Am nt a .NET developer and purely a SQL developer it would be great if I can get examples of using the CLR SP approach.
AS I mentioned earlier I need a way to remove the namespaces from the XML file. Any help in this regard is much appreciated.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply