Post reply

How to call Web Service From Script Task

  • May 11, 2007 at 1:00 am

    #117188

    Hi All,

    Is there any way that I can call a web service inside a Script task in

    SSIS package? I'm not able to add Web reference inside the script

    task

    I know a liitle abt the Web Service task, but I want to pass a XML

    Document as parameter to web service and  the script task is creating

    the XML Document, So instead of saving it in a temp location, is there

    any way that I can send the XML from script task itself?

    Or Can I store the resultant XML to a variable, so that I can use the

    variable in the web service? I tried this way, but attempt was

    unsuccessful

    Any help will be highly appreciated.

    Regards

    Kiran

  • May 14, 2007 at 3:03 am

    #706145

    you can overload your webservice to accept serialised xml then i think you can store it as a variable in the script. how big is your xml output?

    Everything you can imagine is real.

  • May 14, 2007 at 5:44 am

    #706177

    Thanks For the Reply...

    I dont have access to customize the Web Service, I can make use of the exposed Web methods.. Thats all...  

    Regards

    Kian

  • May 14, 2007 at 5:49 am

    #706178

    can you post the webservice parameter definition

    e.g. ws.addTwoNumber(int a, int b)

    Everything you can imagine is real.

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

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