title: How to resolve SSIS error "Excel File is already opened exclusively by another user"?
body: <p><strong>Problem</strong>:</p>
  
  <p>I have an SSIS package that I created in Visual Studio 2015 for SQL Server 2012.  The package loads a tab delimited file and some records from CRM, does some processing, and logs errors in an excel file on a shared drive.  When I run the package from within Visual Studio, the package executes correctly without error.  However, when I deployed the package to the server and tried to run the package from the server as a job, I get the error:</p>
  
  <blockquote>
    <p>The Microsoft Access database engine cannot open or write to the file. It is already opened exclusively by another user, or you need permission to view and write its data.</p>
  </blockquote>
  
  <p><strong>Attempted solutions</strong>:</p>
  
  <ul>
  <li><p>I have checked the folder permission for where the excel file is located and changed them to allow everyone to have full access to the folder.  I did this to the share as well as to the folder and individual file</p></li>
  <li><p>I tried running the package directly and as a part of a SQL Server job</p></li>
  <li><p>I am able to open the file independent of the application so it doesn't appear to be locked by another user</p></li>
  </ul>