title: SSIS - Composite characters
body: <p>I have a flat file and one of the column in the flat file has composite characters and In the Flat File connection manager I defined that particular column as </p>
  
  <p><strong>DataType - DT_WSTR</strong></p>
  
  <p><strong>OutputColumnWidth - 40</strong> </p>
  
  <p>The actual column length in text file is 30 but as this has composite keys I increased it to 40. Now I placed a Dataviewer after the Flat File Source to see how the data is passed and I see different values For example <em>Société</em> is passed as <em>SociÃ©tÃ©</em></p>
  
  <p>Kindly help me to prevent this character conversion. </p>
  
  <p>Please let me know if you need additional details. Thanks in advance</p>