none
How to work with WSDL files to - generate XML file as output to local machine ? Or to write the nodes's data of WSDL to various columns of DB Table ? RRS feed

  • Question

  • Hi,

    I have WSDL file which can give me employee details such as Emp_Code, Emp_Last_Name, Emp_First_Name.

    I can see two web methods while i use Web Service Task: one is groupID based & the other one is groupName based.

    for each group ... there can be more than one employee.

    so, i would like to achieve one of the below things:

    1. Do HTTP connection to WSDL - generate XML File as an output to location with data

    2. Or get the details of Emp_Code, Emp_Last_Name, Emp_First_Name by reading from WSDL & store it in DB Table

    Can anybody suggest me pls how to do it !!!

    Note: This is the thread i already tried but i got empty variables as we can in Watch list in screenshots.

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/51b6ead8-397f-4a84-921a-a45098c036bc/web-service-task-xml-task-values-are-empty-while-trying-to-read-from-xpath-can-someone-help-me?forum=sqlintegrationservices

    thanks a lot in advance !

    best regards, Venkat !!!


    • Edited by G.V.Naidu Tuesday, July 1, 2014 7:51 AM
    • Moved by ArthurZ Tuesday, July 1, 2014 6:12 PM
    Tuesday, July 1, 2014 7:51 AM

All replies