Hello, I received lines of "Data Truncation" messages when I tried to import data from csv into table. Image attached. Can someone help me troubleshoot which column it is causing this? "Data Truncation" is very vague right now, and no records are imported even though from the Job run, it says 200 rows read. Your helps is appreciated!
After changing field separator, I received the following warning, and thus, no rows inserted. For input string: ""1333"" Is there a reason why Job still completed successfully even though there's such warning and data wasn't imported? Is there a way to trigger java exception when import validation fails or no rows are imported? Thanks!
Additional Question - If column separator is comma, but each field is has quoted identifier around it(ie "http://talend.org,Story=rss"), what should I include in the Text enclosure or Escape char? I used "''''"", but received Error Message - "Invalid character constant" Thanks in advanced!
Hello
Do you do 'create table' action on tOracleOutput? Can you upload some screenshot of tOracleOutput?
About the double quote, you need check the 'csv' option, set the escape char as """, text enclosure """
Best regards
shong
Hi captainlaw. FYI, you can link a rejects flow from your tMSSqlOutput component, which will contain a detailed error message as to which field caused the problem in MSSQL.
