title: Exporting Data to Excel file From Sql Server 2014 using SSIS 2012
body: <p>I am using windows 8.1, office 2013, Visual Studio 2013, SQL Server 2014 and SSIS 12.0</p>
  
  <p>I have a data flow which has OLE DB source, Data Conversion And Excel Destination.
  My OLEDB Source<br>
  <a href="https://i.stack.imgur.com/r6pGz.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/r6pGz.jpg" alt="enter image description here"></a>
  Data Conversion
  <a href="https://i.stack.imgur.com/XjmVA.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XjmVA.jpg" alt="enter image description here"></a>
  I have create a Excel file StudentInfo.xls in (C:\XX) folder and make a connection 
  <a href="https://i.stack.imgur.com/BRycj.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BRycj.jpg" alt="enter image description here"></a></p>
  
  <p>Everything is OK, but when I execute it I giving me the following errors:</p>
  
  <blockquote>
    <p>Error: 0xC0209303 at DynamicExcel, Connection manager "Excel Connection Manager": The requested OLE DB provider
    Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not
    installed, run the package in 32-bit mode. Error code: 0x00000000.
        An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".</p>
    
    <p>Error: 0xC020801C at Data Flow Task, Excel Destination [24]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The
    AcquireConnection method call to the connection manager "Excel
    Connection Manager" failed with error code 0xC0209303.  There may be
    error messages posted before this with more information on why the
    AcquireConnection method call failed.</p>
  </blockquote>
  
  <p>This link (<a href="http://microsoft-ssis.blogspot.com/2012/09/swtich-package-from-64bit-to-32bit.html" rel="nofollow noreferrer">Switch package from 64bit to 32bit</a>) led me to change the <code>Run64BitRuntime</code> property to <strong>False</strong>.</p>
  
  <p>After changing the property, I am now getting a different set of errors: </p>
  
  <blockquote>
    <p>Error: 0xC0202009 at DynamicExcel, Connection manager "Excel
    Connection Manager": SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB
    error has occurred. Error code: 0x80004005. An OLE DB record is
    available.  Source: "Microsoft JET Database Engine"  Hresult:
    0x80004005  Description: "The Microsoft Jet database engine cannot
    open the file ''.  It is already opened exclusively by another user,
    or you need permission to view its data.".</p>
    
    <p>Error: 0xC020801C at Data Flow Task, Excel Destination [24]: SSIS
    Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The
    AcquireConnection method call to the connection manager "Excel
    Connection Manager" failed with error code 0xC0202009.  There may be
    error messages posted before this with more information on why the
    AcquireConnection method call failed.</p>
  </blockquote>