Hello All,
i am very new to SSIS and seeking some guidance on a task that i am trying to achieve.
I am consuming an asmx webservice using SSIS.
URL - https://<my website="">/webservice folder/General.asmx
this General.asmx has a method called Authenticate() and it asks for User Name and Password. Once authenticated it returns me an XML containing session token.
Using the session token I need to consume another webservice.
URL - https://<my website="">/webservice folder/AccessControl.asmx
This AccessControl.asmx has a method called GetUser() and it takes two parameters. 1. Sessions token [Received from the step above] 2.UserID. this returns and XML with all the details of the user.
What I have tried:
I am able to generate the XML with session token using a webservice task. But I am not sure how to store the session token in a variable and then use in another web service task to get the user details.
I tried creating a variable in SSIS (user::SessionToken). But It captures XML. But I need the session string, so that i can pass in the second web service call.
the XML for SessionToken looks like this
="1.0"="utf-16"
<string>F42125C05186F77B38CEBA1B31E66DB6</string>
Kindly help.
Regards,
Swayam