title: Looping through XML node using ForEach loop container via SSIS
body: <p>Below is my XML file</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="ISO-8859-1"?&gt;
   &lt;DataResult&gt;
    &lt;Data&gt;
     &lt;Name lang="eng"&gt;Reshma&lt;/Name&gt;
     &lt;Birth Date&gt;1988-09-23T00:00:00&lt;/Birth Date&gt;
    &lt;/Data&gt;
   &lt;Data&gt;
     &lt;Name lang="eng"&gt;Rahul&lt;/Name&gt;
     &lt;Birth Date&gt;1991-09-23T00:00:00&lt;/Birth Date&gt;
   &lt;/Data&gt;
  &lt;/DataResult&gt;
  </code></pre>
  
  <p>I am trying to read this XML node value into the for each loop container, below is the my for each loop container setting,</p>
  
  <p><img src="https://i.stack.imgur.com/XR4XG.png" alt="enter image description here"></p>
  
  <p>Now I want to read that <strong>Name</strong> node value from above XML file and enter that value into database, can't I take a single variable first read the first <strong>Name</strong> node value into it and update the database and again rewrite the same variable by another <strong>Name</strong> node and update the database, since my main xml file is going to have n numbers of <strong>Name</strong> node. </p>
  
  <p>My main aim is to read the xml file node into foreach loop, tried lot for it but unable to get the solution, any help will be greatly appreciated.</p>