title: Is there a way to export huge amount of data (more than a million rows) from SQL Server to csv?
body: <p>I have no trouble exporting to csv files using ssis when the number of rows is less than 500k. I get the following error when the size gets bigger</p>
  
  <blockquote>
    <p>DT_TEXT, which is not supported with Unicode files. Use DT_NTEXT
    instead and convert the data to DT_TEXT using the data conversion
    component.</p>
  </blockquote>