title: ssis sql 2000 image to 2008 varbinary Failed to retrieve long data for column
body: <p>I have a task that to migrate the image type column from sql 2000 to varbinary type in sql 2008.</p>
  
  <p>The source column having 3812353 max datalength size for the column.
  The package always failed with following error message.</p>
  
  <p>[OLE DB Source [13177]] Error: Failed to retrieve long data for column "attch_file_content_t".</p>
  
  <p>[OLE DB Source [13177]] Error: There was an error with output column "attch_file_content_t" (13209) on output "OLE DB Source Output" (13187). The column status returned was: "DBSTATUS_UNAVAILABLE".</p>
  
  <p>[OLE DB Source [13177]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "output column "attch_file_content_t" (13209)" failed because error code 0xC0209071 occurred, and the error row disposition on "output column "attch_file_content_t" (13209)" 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.</p>