Good morning all, I am working in CF 9. I have a web service that I am trying to consume with a SQL2008 SSIS web service task.
I am getting a "The given service is not currently available". SSIS generates the WSDL file correctly. I have to manually add the method I want by editing the package XML, but that seems to be a not uncommon bug with the web service task in SSIS. I can consume the service using <cfinvoke>. The following returns the correct data: <cfinvoke webservice="http://localServerName/.../sears.cfc?wsdl"; method="getProductFeed" returnvariable="dtsFeed"> <cfinvokeargument name="lastEntryId" value=621901 /> </cfinvoke> <cfdump var="#dtsFeed#"> but SSIS won't consume it. Has anyone ever had this issue? I'm wondering if some of the attributes need to be set explicitly for SSIS? Thanks, Kathryn ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349613 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
