Talend incorrect Data truncation error

Anonymous — Fri, 19 Oct 2018 14:00:21 GMT

Hello! I am creating a table in SQL server 2014 using Talend. Below is table creation code

Create table [dbo].[demo]
(
 Name varchar(50),
 Description varchar(max) -- data truncation issue for this column
 )

 insert into [dbo].[demo] (Name,Description)
 values ('VJ','<characters more than 8000>')

The table has been successfully created no problems here datatype it is what i want. But when I try to insert data from CSV into same above table it complains about data truncation. Since there are only 2 columns I could identify which column has characters more than 8000 it was Description column.

But here's my doubt, when I say datatype of Description column is varchar(max) then why am I getting this error in Talend because when executed same code directly in SQL server it runs perfectly.

I added reject flow so now there is no Data truncation error in the console but still some rows are going in reject flow and I want all the rows in my table.

Talend Data Fabric 6.3.1

Java 8

Sql server 201

Re: Talend incorrect Data truncation error

Anonymous — Fri, 19 Oct 2018 14:27:10 GMT

Can you post the whole error you get when running and send a screenshot of your job please?

Re: Talend incorrect Data truncation error

Anonymous — Fri, 19 Oct 2018 14:58:34 GMT

I have attached sample job design. Please note I have added rejects flow so now there is no Data truncation error but instead 406 rows are not inserted in my table. I want all the rows to be inserted without any truncation.

topic Re: Talend incorrect Data truncation error in Talend Studio

Talend incorrect Data truncation error

Re: Talend incorrect Data truncation error

Re: Talend incorrect Data truncation error