title: SSIS foreach ADO Enumerator duplicate rows in object
body: <p>Hello i am building a SSIS package which get the delta snapshot date's and processed them to the SCD 2 Dimension. Everything goes fine except the "Foreach ADO enumerator" which caused duplicate SNAPSHOTS except the last row.  To realize this i look at the following source:</p>
  
  <ul>
  <li><a href="http://www.codeproject.com/Articles/14341/Using-the-Foreach-ADO-Enumerator-in-SSIS" rel="nofollow noreferrer">http://www.codeproject.com/Articles/14341/Using-the-Foreach-ADO-Enumerator-in-SSIS</a></li>
  <li><a href="https://www.simple-talk.com/sql/ssis/implementing-foreach-looping-logic-in-ssis-/" rel="nofollow noreferrer">https://www.simple-talk.com/sql/ssis/implementing-foreach-looping-logic-in-ssis-/</a></li>
  </ul>
  
  <p>How can i fix the problem of the double loop.</p>
  
  <p>This package is developed in the following enviroment:</p>
  
  <ul>
  <li>Windows 2008 Server R2 Enterprise</li>
  <li>SQL Server 2012</li>
  <li>BIDS 2013</li>
  </ul>
  
  <p>The pictures below shows how this is implented:</p>
  
  <p><a href="https://i.stack.imgur.com/4gMeN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4gMeN.png" alt="enter image description here"></a>
  <a href="https://i.stack.imgur.com/S7yg3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/S7yg3.png" alt="enter image description here"></a></p>
  
  <p><strong>SSIS Variable</strong>
  <a href="https://i.stack.imgur.com/Ynopa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ynopa.png" alt="enter image description here"></a>  </p>
  
  <p><a href="https://i.stack.imgur.com/pvJPa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pvJPa.png" alt="enter image description here"></a>   </p>