title: SSIS truncated error returned status 4
body: <p>I m trying to import file from <code>Excel</code> into an <code>SQL table</code>. When i convert from unicode <code>string[DT_WSTR]</code> to <code>string[DT_STR]</code> with data conversion i get a truncation error on some columns. This is output error:</p>
  
  <blockquote>
    <p>[Data Conversion [2]] Error: Data conversion failed while converting column "Contact Name" (187) to column "DataContactName" (105).  The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".</p>
  </blockquote>
  
  <p>So data flow finish as failure, but some rows are copied to <code>sql table</code>.
  Is there some workaround or what is solution to this? </p>