title: How to go from XML file with a stucture having a parent node and a child node to a structure with only one level
body: <p>Using ssis 'XML task', is there a XSL that makes it possible to go from an xml file with a parent node and child node to a xml file with only one level: same number of occurrences in the child node in the input xml as in the number of occurrences in the output xml. Here an example</p>
  <p><strong>Input xml</strong></p>
  <pre><code>&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
  &lt;RL&gt;
    &lt;RL0601a&gt;BEAUDRY&lt;/RL0601a&gt;
    &lt;r&gt;
      &lt;RL0104B&gt;61&lt;/RL0104B&gt;
      &lt;RL0104C&gt;2095&lt;/RL0104C&gt;
    &lt;/r&gt;
    &lt;r&gt;
      &lt;RL0104B&gt;64&lt;/RL0104B&gt;
      &lt;RL0104C&gt;1090&lt;/RL0104C&gt;
    &lt;/r&gt;
  &lt;/RL&gt;
  </code></pre>
  <p><strong>Output xml</strong></p>
  <pre><code>&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
  &lt;RL&gt;
  &lt;r&gt;
      &lt;RL0601a&gt;BEAUDRY&lt;/RL0601a&gt;
      &lt;RL0104B&gt;61&lt;/RL0104B&gt;
      &lt;RL0104C&gt;2095&lt;/RL0104C&gt;
  &lt;/r&gt;
  &lt;r&gt;
      &lt;RL0601a&gt;BEAUDRY&lt;/RL0601a&gt; 
      &lt;RL0104B&gt;64&lt;/RL0104B&gt;
      &lt;RL0104C&gt;1090&lt;/RL0104C&gt;
  &lt;/r&gt;
  &lt;/RL&gt;
  </code></pre>