Post reply

can't see where to put in web service task input parameters -- is it a bug?

  • April 19, 2010 at 2:15 pm

    #233998

    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

    #1154773

    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

    #1154872

    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

    #1245263

    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