title: Is SSIS faster if run from the server that the data is on?
body: <p>Say I am copying data from Database A to Database B and both of them are on the same Sql Server.  I am taking data from a table and putting it into another table (no transforms).</p>
  
  <p><strong>Does the performance improve noticeably if I run the SSIS package on the server that hosts the databases?</strong>  (As opposed to running it on a dedicated SSIS server.)</p>