title: SSIS and 64-bit Microsoft Access Database Engine
body: <p>Our dev server has SQL Server 2008 R2 64-bit with SSIS. In order to be able to import XLSX files directly from T-SQL (via <code>OPENROWSET</code>), we installed on the dev server the <code>Microsoft Access Database Engine Redistributable 64-bit</code>. The server already has the 32-bit version installed, so we installed it with the /passive switch.</p>
  
  <p>Since doing that, our existing packages are failing. One of them reports</p>
  
  <blockquote>
    <p>The step did not generate any output.  The return value was unknown. 
    The process exit code was -1066598274.  The step failed.</p>
  </blockquote>
  
  <p>Just wondering if anyone else has successfully configured their server to be able to use <code>OPENROWSET</code> to XLSX files and also have SSIS on the same server, Or does someone know if this configuration is not possible?</p>
  
  <p><em>Edit:</em> I should add that the failing packages are run from an SQL Agent job. When I connect to the server's Integration Services Manager via SQL Server Management Studio and run the package (by navigating to the package, right-clicking it and selecting Run Package), it executes successfully.</p>