title: Export image data to flat file
body: <p>I'm trying to export my image data from a table to a flat file using "Export Data" wizard. I've specified the query "Select picture from Profile", in SSIS to export only the data in "picture" coloumn. When I run the package, I get the following error:</p>
  
  <blockquote>
    <p>The data type for "input column
    "picture" (26)" is DT_IMAGE, which is
    not supported. Use DT_TEXT or DT_NTEXT
    instead and convert the data from, or
    to, DT_IMAGE using the data conversion
    component.</p>
  </blockquote>
  
  <p>How can I export the data to flat file</p>
  
  <p>Thanks in advance.</p>