April 19, 2010 at 2:15 pm
I am working with SSIS 2008 web service task. I am able to connect to the http endpoint and enter my web service and method, but when selecting method I do not get the grid that is supposed to display the variables list. That is perplexing me and I have found nothing useful out on the web. I am running SQL Server 2008 development edition with service pack 1 and am building my SSIS package locally.
I can call the web service from a different application and enter variables, but not from SSIS.
Is this a known bug and is there a solution?
I have attached my wsdl for those who can decipher it.
I appreciate any help or insight you can offer!
Karen
April 20, 2010 at 10:42 am
Since I was unable to resolve this issue, I decided to use the script task to call the web service. I was able to run this successfully! I am interested is finding out if anyone else has had this issue and if there is actually a resolution using the web service task.
Karen
April 20, 2010 at 12:48 pm
The problem is in your wsdl, looks like it could be a namespace referencing issue?
For e.g. the the addSubscriber item. If you remove the reference to the tns:addSubscriber, and drop the complextype in as part of the element like below, then you get the parms presented.
<xs:element name="addSubscriber" >
<xs:complexType name="addSubscriber">
<xs:sequence>
<xs:element minOccurs="0" name="ExactTargetClientID" type="xs:string" />
<xs:element maxOccurs="unbounded" minOccurs="0" name="EmailListToAdd" type="xs:string" />
<xs:element minOccurs="0" name="IsUnsubscribe" type="xs:boolean" />
</xs:sequence>
</xs:complexType>
</xs:element>
It's not clear why SSIS isn't liking that namespace.
hth,
Steve.
November 2, 2010 at 4:41 am
Hi Karen
I'm a real newbie when it comes to web services, so forgive me if I ask any stupid questions.
Is possible you can provide me with an example of how you are using the script task to call the web service.
I've got a similar requirement to call a web service. Much like yourself, I can get the server ok, but the Methods list, does not provide any selectable options........... :crazy:
I'm going to look at the WSDL and see if I can apply what Steve Oz has suggested looking at. but an example would be helpful.
Also, the software firm we are dealing with, provided details of how to connect via a vb app development (not our preferred choice, but they basically say that we must use a 'MyInstallID' and a 'cono' reference, neither of which the Web Service tasks have a input option for??
Is this something relevant to all web service calls or just how it's been implemented for our situation.
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply