title: How to resolve data conversation failed in ssis package
body: <pre><code>[Flat File Source [96]] Error: Data conversion failed. The data conversion for column "description" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
  </code></pre>
  
  <p>I am trying import csv file data into SQL server.i am using datatype nvarchar(4000) in sql .But in Flatfilesource proprties and Oledb Properties using same unicode STRING DT-WSTR.Before getting error cannot convert unicode and non unicode .That is why now i am using through data conversion control mapping the columns.Even if both datatype have same still getting this error.pls reply any one as soon as possible.</p>