Consuming a WSDL Webservice from SQL Server 2000?

[wbodger]

I have to grab data regularly from a WSDL webservice to update my customer database. Is it possible to have this run strictly as a DTS package in SQL Server 2000? If not, then would it work with SSIS in SQL Server 2008R2?

I have found samples for consuming a WSDL webservice in classic ASP, but I would like to run this strictly thru SQL Server.

Thanks,
Willie

 

[philhege]

You'll need to construct a CLR-based stored procedure (SQL2K5/8) that can make the Web service function call and retrieve the data.

The only way to do this in SQL 2K is with an extended stored procedure.

-------++NO CARRIER++-------

 

[wbodger]

So, if I have C# code samples for consuming this WSDL webservice, how do I go about getting started with either of these? My db is currently SQL 2K, but if I can ever get my new hardware I should be migrating it to 2008R2 sooner than later.

Thanks,
Willie