title: SSIS Data Conversion keeps switching back to Unicode
body: <p>In SSIS I am querying the Active Directory for a list of domain users.  The results (according to SSIS) are of data type 'Unicode text stream [DT_NTEXT]'.</p>
  
  <p>I am using the Data Conversion item from the SSIS Toolbox to translate all the field before inserting them into an SQL table.  I can go in and give each field an Output Alias and an output 'Data Type of String [DT_STR]' (I tried in the default options window and in the Advanced Properties window).  I click OK to save my settings, but the red X is still there saying it can't convert to Unicode and if I reopen the properties window all the Data Types are set back to Unicode.</p>
  
  <p>Has anyone had this happen to them before?  </p>