title: SSIS Flat-file source - Text was truncated or one or more characters had no match in the target code page
body: <p>I'm trying to import records into an SQL database file from a comma-delimited flat file and I get a "Text was truncated or one or more characters had no match in the target code page." when the source file has more than 50 characters in a particular field. The Destination file target for that field is 1000 characters, so that shouldn't be an issue.  I narrowed it down to "A123456789B123456789C123456789D123456789E123456789" in the text file did import while "A123456789B123456789C123456789D123456789E123456789F" threw the error.</p>
  
  <p>How can I get it to allow more characters before truncating?</p>