https://community.qlik.com/t5/Talend-Studio/resolved-tMSSqlOutput-field-size-problem/m-p/2301107#M73257 Hi Bob <BR />In MS SQL the maximum varchar length is 8000. If you need larger field content, you need to change that column to TEXT. <BR />Best regards <BR />Shong Thu, 30 Jun 2011 09:24:08 GMT Anonymous 2011-06-30T09:24:08Z https://community.qlik.com/t5/Talend-Studio/resolved-tMSSqlOutput-field-size-problem/m-p/2301106#M73256 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.<BR />Exception in component tMSSqlOutput_1<BR />java.sql.SQLException: The size (20480) given to the column 'WBSLABST_T' exceeds the maximum allowed for any data type (8000). <BR />The DB2 field is identified as a type string. Is there another field type that will allow me to create the new SQL tables? <BR />Any ideas would be appreciated.<BR />Thanks, Bob Sat, 16 Nov 2024 12:50:21 GMT https://community.qlik.com/t5/Talend-Studio/resolved-tMSSqlOutput-field-size-problem/m-p/2301106#M73256 Anonymous 2024-11-16T12:50:21Z https://community.qlik.com/t5/Talend-Studio/resolved-tMSSqlOutput-field-size-problem/m-p/2301107#M73257 Hi Bob <BR />In MS SQL the maximum varchar length is 8000. If you need larger field content, you need to change that column to TEXT. <BR />Best regards <BR />Shong Thu, 30 Jun 2011 09:24:08 GMT https://community.qlik.com/t5/Talend-Studio/resolved-tMSSqlOutput-field-size-problem/m-p/2301107#M73257 Anonymous 2011-06-30T09:24:08Z