title: Error while exporting data of datatype "Text" in SQL Server 2008r2 to Excel data type "long text"
body: <p>I am new to Databases. I  am trying to export data from <code>SQL Server 2008r2 server</code> to <code>Excel 2010</code>. One of the columns in the Database is of type <code>text</code> and since I want to export the data into Excel 2010, I am selecting destination data type as <code>longtext</code>. </p>
  
  <p>I am encountering the following error:</p>
  
  <blockquote>
    <p>Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component “Data Conversion 0 – 0” (39) failed with error code 0xC0209029 while processing input “Data Conversion Input” (40). 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.</p>
  </blockquote>
  
  <p><strong>SQL Server Import and Export Wizard</strong></p>
  
  <p>Further, I am successfully able to export the data if I choose Ignore error and Ignore truncation option, but this gives me truncated data.</p>
  
  <p>Is there any solution to this problem?</p>