Post reply

How can be pass the parameter with Web Method in Web service Task

  • May 12, 2009 at 1:37 am

    #200378

    Hi

    i have one XML File. in this XMl file i have comma separated value (Fool,Foo2,Foo3.........)like this. i want to pass this comma separated value as parameter with web method in Web service task. how can be do by SSIS.

    Regards,

    HEmant

  • May 12, 2009 at 2:21 am

    #992683

    So which bit are you asking for help on? Retrieving the string from an XML file (which appears to be masquerading as a CSV file) or using the retrieved string as a parameter?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • May 12, 2009 at 3:26 am

    #992703

    Retriving the string from XML file. that i want to use as parameter in Web method in Web service task. Web method is input in Web service Task. suppose i am getting the XML as (Foo1,Foo2..)

    so at the one time input should be Foo1, next time F002

    Please let me know in case of any concerns.

  • May 12, 2009 at 4:11 am

    #992723

    So you have a single string:

    "Foo1, Foo2, etc etc"

    and you want to issue a call to a web service multiple times - once for each item in the list?

    Sorry if I am being a little slow in understanding, but your English is not 100% clear to me 🙂

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply