title: Import/Export wizard fails on export to Excel
body: <p>I am exporting a table from sql server to Excel using the SSIS Import/Export wizard. In Proceed step, I get a warning icon in each record regarding conversion of types. If I ignore then the export fails after clicking Finish in the last screen.</p>
  
  <p>I search in Stack Overflow regarding this but unable to get relevant answer...</p>
  
  <p>SQL table fields and their type are below:</p>
  
  <pre><code>CREATE SomeTable
  (
      EmpId numeric(9)
  ,   Name varchar(50)
  ,   Address varchar(50)
  ,   ContactNo varchar(50)
  );
  </code></pre>
  
  <p>Error that comes is written below</p>
  
  <blockquote>
    <p>Copying to <code>tblSSISFlatImport</code> (Error) Messages Error 0xc0202009: Data
    Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has
    occurred. Error code: 0x80004005.  (SQL Server Import and Export
    Wizard)   Error 0xc0209029: Data Flow Task 1: SSIS Error Code
    DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "input "Destination Input"
    (39)" failed because error code 0xC020907B occurred, and the error row
    disposition on "input "Destination Input" (39)" specifies failure on
    error. An error occurred on the specified object of the specified
    component.  There may be error messages posted before this with more
    information about the failure.  (SQL Server Import and Export Wizard)</p>
    
    <p>Error 0xc0047022: Data Flow Task 1: SSIS Error Code
    DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component
    "Destination - tblSSISFlatImport" (28) failed with error code
    0xC0209029 while processing input "Destination Input" (39). The
    identified component returned an error from the ProcessInput method.
    The error is specific to the component, but the error is fatal and
    will cause the Data Flow task to stop running.  There may be error
    messages posted before this with more information about the failure. 
    (SQL Server Import and Export Wizard)</p>
  </blockquote>