title: What are the hops involved in ssis package working with network file and/or remote SQL Server?
body: <p>Assuming my SSIS package has:</p>
  <ul>
  <li>Network file process (copy task)</li>
  <li>Network flat file source task (that reads the file)</li>
  <li>Oledb sql source task that reads data from table located on remote server (windows authentication)</li>
  </ul>
  <p>Suppose I run the package using either of:</p>
  <ol>
  <li><p>Visual Studio (runs with credentials of Visual Studio user)</p>
  </li>
  <li><p>SSIS catalog (right click package and execute, runs with credentials of SSMS user)</p>
  </li>
  <li><p>SQL Server agent job step (runs Under credentials of SQL Server service user)</p>
  </li>
  <li><p>SQL Server agent job with step using Run As based on proxy credentials (runs under credentials of proxy)</p>
  </li>
  </ol>
  <p>My understanding is that in all the 4 situations, only 1 hop is involved. But there are articles I have been reading and colleagues that are suggesting that there are 2 hops involved and I will have to deal with Kerberos without being able to explain to me where is the 2nd hop in this situation? Can someone advise?</p>