title: Export data to excel by using SSIS
body: <p>I am trying to export the data to excel by using SSIS packages.</p>
  
  <p>I have created the data flow task and then selected excel destination as savnig the data. Then try to work on the excel connection manager and I have got the issues to export the data into Sheet 1 of the destination folder excel file.
  I had to create a table by using Excel Connection editor and then its loading the data to the newly created sheet in destination excel file. I don't want to have two sheets in the excel file as one is with the exported data and another one is with empty with just headers alone.</p>
  
  <p>I am getting the below errors when try to export the data to Sheet 1</p>
  
  <blockquote>
    <p>[Excel Destination [12]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An
    OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is
    available.  Source: "Microsoft JET Database Engine"  Hresult:
    0x80040E21  Description: "Multiple-step OLE DB operation generated
    errors. Check each OLE DB status value, if available. No work was
    done.".</p>
    
    <p>[Excel Destination [12]] Error: An error occurred while setting up a
    binding for the "List" column. The binding status was "DT_NTEXT".</p>
    
    <p>[Excel Destination [12]] Error: Cannot create an OLE DB accessor.
    Verify that the column metadata is valid.</p>
    
    <p>[SSIS.Pipeline] Error: Excel Destination failed the pre-execute phase
    and returned error code 0xC0202025.</p>
  </blockquote>
  
  <p>But it works fine perfectly when i export the data to newly created sheet "Excel Destination". </p>
  
  <p>Please see the below screenshot for that.</p>
  
  <p><a href="https://i.stack.imgur.com/VawB6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VawB6.png" alt="Excel Destination editor screenshot"></a></p>