SSIS - Text was truncated or one or more characters had no match in the target code page
This is one common error that SSIS developers confronts while pulling data from CSV files. There may be two issues related to this, one is due to size of the CSV connection file field is less compared to the original file and the second one is due to different code page. I had one CSV file for which data extracted from Oracle database and here is the connection settings Fig 1 Here is code page is 65001(UTF-8) and when I tried to run the package, I got the error. Fix for this error is simple, text qualifier for this CSV file is " and when I given quotes in the text qualifier in connection properties this error vanished. Fig 2