title: SSIS complex xml multiple outputs priority
body: <p>I have xml files with data in the format:</p>
  
  <pre><code>&lt;parent fieldone="good" valuetwo="100"&gt;
    &lt;employees&gt;
      &lt;employeename&gt;
    &lt;/employee&gt;
    &lt;customers&gt;
      &lt;customername&gt;
    &lt;/customers&gt;
   &lt;/parent&gt;
  </code></pre>
  
  <p>etc</p>
  
  <p>Trying to import this as a complex xml using SSIS but I need the data in the parent element attributes to be imported first, so that foreignkey constraints are complied with.</p>
  
  <p>Prior to the xml import source routine I used SSIS SQL data task to obtain the highest/last id for the parent level xml's corresponding table. I then apply that value +1 to a variable (call it ParentId) which is used for all child tables in their foreignkey fields.</p>
  
  <p>Then all of the xml source outputs are mapped to tables, including the xml parent level and corresponding table. I'm relying on this insert to create the id that I am assuming (i.e. the one I have assigned to the variable ParentId)</p>
  
  <p>But the import fails because the parent output is not being processed first, so it never inserts that record and the parentid I am assuming is never generated.</p>
  
  <p>Is there a way to enforce a priority or order that the xml source outputs are processed?</p>