[resolved] tMSSqlOutput field size problem

[Anonymous]

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

[Anonymous · Accepted solution]

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