[resolved] tMSSqlOutput field size problem

One Star

[resolved] tMSSqlOutput field size problem

I have been converting DB2 tables to MS SQL tables and have run into a problem. In a couple of tables I have really large fields +20k in length. I am getting the following error when running the table creation process.
Exception in component tMSSqlOutput_1
java.sql.SQLException: The size (20480) given to the column 'WBSLABST_T' exceeds the maximum allowed for any data type (8000).
The DB2 field is identified as a type string. Is there another field type that will allow me to create the new SQL tables?
Any ideas would be appreciated.
Thanks, Bob

Accepted Solutions
Community Manager

Re: [resolved] tMSSqlOutput field size problem

Hi Bob
In MS SQL the maximum varchar length is 8000. If you need larger field content, you need to change that column to TEXT.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] tMSSqlOutput field size problem

Hi Bob
In MS SQL the maximum varchar length is 8000. If you need larger field content, you need to change that column to TEXT.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business