Click here to Skip to main content
15,937,779 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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

<?xml version="1.0" encoding="utf-16"?>

Kindly help.


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900