> 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?
Are you sure your service can be invoked from an external machine? Can you create a "hello world" service and test invoking that from SSIS? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or on ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:349616 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
