title: SSIS Failed to retrieve long data for column varchar(max)
body: <p>I want build a package that imports excel rows to an SQL server table, the problem is that sometimes there is an error that fails the package process. </p>
  
  <blockquote>
    <p>[Excel Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB
    error has occurred. Error code: 0x80040E21. [Excel Source [1]] Error:
    Failed to retrieve long data for column "RECOMENDACION". [Excel Source
    [1]] Error: There was an error with output "Excel Source Output" (9)
    on component "Excel Source" (1). The column status returned was:
    "DBSTATUS_UNAVAILABLE".</p>
  </blockquote>
  
  <p>as you can see, there is something wrong with the column "RECOMENDACION". </p>
  
  <p>Note: the error is in Excel Source task.</p>