Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS consuming a web service

Author  Topic 

SQL_Rookie
Starting Member

32 Posts

Posted - 2008-06-23 : 09:19:42
I have a thrid party web service that I'm trying to call from SSIS but the web service doesn't have a wsdl and I can not generate one using wsdl.exe. I also contact the thrid party and they told me they don't have a wsdl and not supported. So I'm stuck. They mentioned that I have to use HTTP POST. So in the webservice task wizzard I can not set the wsdl and the wizzard complains without this setting. So how can I use SSIS to consumer this web service it would be really nice to use this web service task other then custom script task and connect to the web service via custom code. Any ideas or pass expereinces on how to do this?
   

- Advertisement -