title: Consuming web service in SSIS
body: <p>In my project,  I have simply created the web service for addition of number and returning the result in variable from web service task via SSIS as explained in following screen,</p>
  
  <p><img src="https://i.stack.imgur.com/Fb6DA.png" alt="enter image description here"></p>
  
  <p>when I am using file connection mode then I am getting xml file saved on my hard drive in the following format,</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-16"?&gt;
  </code></pre>
  
  <p>35</p>
  
  <p>I have did following attempt to insert that result that is 35 in my database table either by file connection or through variable</p>
  
  <ol>
  <li><p>I have created Execute SQL task to perform query by procedure, follow the link
  <a href="https://stackoverflow.com/questions/18720095/error-on-executing-sql-task-in-ssis">enter link description here</a></p></li>
  <li><p>And also I tried to run Execute SQL task by accessing variable, follow the link
  [<a href="https://stackoverflow.com/questions/18691959/inserting-data-into-sql-server-from-variables-via-ssis">Inserting Data into SQL Server from variables via SSIS</a><a href="https://stackoverflow.com/questions/18691959/inserting-data-into-sql-server-from-variables-via-ssis">]</a></p></li>
  </ol>
  
  <p>and now after this all trial, my concern is am I able to successfully store result in user variable from web service as shown in first screen shot since I am getting the empty value of variable as refer in link 2,</p>
  
  <p>but when I am storing data on hard drive then it is successfully storing the result in xml format and if I am incorrect, then please provide the correct procedure or helping links...</p>
  
  <p>My main motto is to run a web service for addition of two numbers and get the result in user defined variable through web service task via SSIS and then insert that acquired data into sql database.</p>
  
  <p>And also, what this double green arrow means in my following screen shot from web service task
  <img src="https://i.stack.imgur.com/qHFC1.png" alt="enter image description here"></p>