title: Transferring SQL Data with SSIS in VS2012
body: <p>I am trying to do this in SSIS (but it does not seem trivial) copy data from source to destination in this manner:</p>
  
  <pre><code>     copy-&gt;(select from source.TableA where source.CallID &gt; (select max(destination.TableA.CallID) from destination.TableA) -&gt; to destination
  </code></pre>
  
  <p>So I am trying to copy some delta data from source based on the aggregate Max(CallID) from destination. </p>