title: Will SSIS extract data through itself in all circumstances?
body: <p>When developing a Azure SQL Data warehouse with SSIS. We have 2-phrase steps 
  to 1) copy data source to staging table, 2) copy staging table to report table</p>
  
  <p>My question is, will SSIS actually extract data through it's own server, even it knows source &amp; target are the same OLE DB provider? Or it's smart enough to use "SELECT INTO FROM SELECT * FROM .."? This makes a difference to us as Azure calculate the cost on exporting data out from Azure, and we have a lot of similar copying actions in DW, and SSIS is the only machine on-premise.</p>
  
  <p>We could define a series of SQL statement tasks with nested query but it's hard to manage for TransactionOption in such a quantity.</p>
  
  <p>Thanks. </p>