data truncation error

[Anonymous]

Dear Sir 

am facing data truncation error when delimit file data move into MSSql output. am already read truncation related post on Talend Community but unable to resolve. 

[vboppudi]

Hi,

Does source and target has same datatype and length for every attribute?

Regards,

[manodwhb]

Data truncation will get,when input column length is lower than output column

[Anonymous]

Hello,

Here is a KB article about:https://community.talend.com/t5/Design-and-Development/quot-Data-truncation-Data-too-long-for-column....

Hope it will help.

Best regards

Sabrina

[Anonymous]

i have already done it but its not work for me.

[Anonymous]

Hi
Do you create the table on tMSSQLOutput component or Does the tables already exist in database?
For testing, you can print the length of column value on the console to see if it exceeds the maximum size of the field.

Regards
Shong

[Anonymous]

am created table for tMSSQL component. i couldn't understand print the lenght of column value on the console. how it will done?

[manodwhb]

@ksingh,you need to get max column length linke below.

Job

tmap

tAggregaterow

[manodwhb]

@ksingh,still do you have issue?