title: Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
body: <p>I'm trying to import a flat file into an oledb target sql server database.</p>
  
  <p>here's the field that's giving me trouble:</p>
  
  <p><img src="https://i.stack.imgur.com/CBYws.png" alt="enter image description here"></p>
  
  <p>here are the properties of that flat file connection, specifically the field:</p>
  
  <p><img src="https://i.stack.imgur.com/GTBcj.png" alt="enter image description here"></p>
  
  <p>here's the error message:</p>
  
  <blockquote>
    <p>[Source - 18942979103_txt [424]] Error: Data conversion failed. The
    data conversion for column "recipient-name" 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>What am I doing wrong?</p>