title: SSIS delete duplicate data
body: <p>I have a problem for making a <code>SSIS</code> package.Can anyone help?<br>
  Here is the case:
  I have two tables: <code>A</code> &amp; <code>B</code>, and the structure is the same. But they are stored on different servers.</p>
  
  <p>I have already made an <code>SSIS</code> package to transfer data from <code>A</code> to <code>B</code> (about one million rows at a time, which takes between one and two minutes).</p>
  
  <p>After that I want to delete table <code>A</code>'s data, after having been transfered to <code>B</code>. The <code>SSIS</code> package I wrote would follow that. I use a <code>merge join</code> and <code>Conditional Split</code> command to select the same data. </p>
  
  <p>After that I use the <code>OLE DB</code> Command to delete Table <code>A</code>'s data (just use <code>"Delete RE_FormTo Where ID=?"</code> SQLCommand to delete). It can work, but it is too slow! It took about one hour to delete the duplicate data! Does anyone know of a more efficient way of doing this? </p>
  
  <p><a href="http://www.flickr.com/photos/92066102@N03/8365934429/in/photostream" rel="nofollow">SSIS Package Link</a></p>