title: Find 'Execute SQL Task' component execution server (SQL Server Integration Services)
body: <p>I've an 'Execute SQL Task' component in SSIS package.</p>
  <pre><code>Connection manager: 'Server A' 
  Database: Finance_Warehouse 
  SQL Query:   SELECT batch_date FROM Finance_Warehouse.etl_audit WHERE
     curr_batch_ind IS NULL 
  SSIS Package: Runs from Server B
  
   
  </code></pre>
  <p><strong>My question:</strong> When I execute SSIS package in 'Server B', where will 'Execute SQL Task' component SQL Query run? Server A or Server B?</p>
  <p>Also, how do I verify that (on which server this component/SQL Query is running)?</p>
  <p>My assumption is that, it will run on 'Server A' as SQL Server is installed in 'Server A', but looking for affirmed answer from experts.</p>
  <p>Thanks in advance,</p>
  <p>Ash</p>
  <p>Trace details:</p>
  <p><a href="https://i.stack.imgur.com/sAMuV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sAMuV.png" alt="trace details" /></a></p>