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
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.
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 |
I enjoy reading your articles. You really have a wonderful blogs. Keep up the good work. Thank you also for the information!
ReplyDeletewww.gofastek.com
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