title: SSIS job fails when run remotely thru ssms, but runs fine on SQL Server
body: <p>Installed SQL Server 2016 on a dev box, with SSIS.<br>
  Have a package that loops thru a directory and validates XML files.  </p>
  
  <p>The job runs fine on the SQL Server from the Integration Services Catalog and from SQL Server Agent, when executed there.  Also runs fine in the local developers PC's.  </p>
  
  <p>The issue comes in if you connect to the SQL Server via SSMS remotely, (Same user) and try to execute the package via Integration Services Catalog, it runs but fails to loop thru files. It gives the following error: 
  <a href="https://i.stack.imgur.com/PkXIm.jpg" rel="nofollow noreferrer">ForEach Error/Warning</a></p>
  
  <p>But when executed on the SQL Server or thru the SQL Server Agent, the job runs fine.  Only when using SSMS connecting remotely does it not loop thru the directory.  Same user credentials are used.  This works on SSIS 2012 /SQL Server 2012. </p>
  
  <p>I have checked and adjust the DCom rights to Launch and Activate.  This had no affect either. </p>
  
  <p>Any ideas why this is not working on SQL Server / SSIS 2016? </p>
  
  <p>Thanks, </p>
  
  <p>Patrick</p>