Hi, I have to insert some data from Excel file into MsSQLServer DB. I have a field that can store up to 200 characters, but it showed error message 'Data Truncation' when I was inserting a record with 20+ characters length. But it worked when I inserted below 20 characters. I already put the same length value between input and output. Until now I still can't find out the cause of this error. Anyone can help?
Could you please take a look at a KB article about:TalendHelpCenter: Exception: Data truncation: Data too long for column to see if it fix your issue?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema