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

Comments

  1. I enjoy reading your articles. You really have a wonderful blogs. Keep up the good work. Thank you also for the information!

    www.gofastek.com

    ReplyDelete
  2. Designing Power BI Reports Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info.

    ReplyDelete

Post a Comment

Popular posts from this blog

Hadoop - Hive - Load data from csv/xls files

Microsoft BI Implementation - Cube back up and restore using XMLA command