Talend incorrect Data truncation error

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.