https://community.qlik.com/t5/Talend-Studio/Manage-MSSQL-Identity-field-with-tCreateTable/m-p/2326997#M96415 You would have to specify the precision too for INT IDENTITY. Just mention Length = 1 &amp; Precision = 1 which would be Seed &amp; Increment respectively.<BR />Also, you have mentioned db type variables as NCHAR but Talend type as Integer. You need to change them too. Fri, 29 Jun 2018 17:45:52 GMT iamabhishek 2018-06-29T17:45:52Z https://community.qlik.com/t5/Talend-Studio/Manage-MSSQL-Identity-field-with-tCreateTable/m-p/2326996#M96414 <P>Hi<BR />I'm trying to make a INT identity field with autoincrement but I get this error :</P> <PRE>Exception in component tCreateTable_1 (File_rotate) java.lang.RuntimeException: Creating table failed at swiss_project.file_rotate_0_1.File_rotate.tCreateTable_1Process(File_rotate.java:1215) at swiss_project.file_rotate_0_1.File_rotate.tFileInputXML_1Process(File_rotate.java:14346) at swiss_project.file_rotate_0_1.File_rotate.tFileList_1Process(File_rotate.java:15702) at swiss_project.file_rotate_0_1.File_rotate.runJobInTOS(File_rotate.java:19262) at swiss_project.file_rotate_0_1.File_rotate.main(File_rotate.java:18988) Caused by: java.sql.SQLException: Identity column 'AST00' contains invalid INCREMENT. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1282) at swiss_project.file_rotate_0_1.File_rotate.tCreateTable_1Process(File_rotate.java:1203) ... 4 more</PRE> <P><BR /><BR /><BR /><BR /><SPAN class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="talend_create_table.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lytk.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139972i20299BCB89BBE169/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lytk.png" alt="0683p000009Lytk.png" /></span></SPAN>Thanks in advance</P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 16 Nov 2024 08:01:32 GMT https://community.qlik.com/t5/Talend-Studio/Manage-MSSQL-Identity-field-with-tCreateTable/m-p/2326996#M96414 Anonymous 2024-11-16T08:01:32Z https://community.qlik.com/t5/Talend-Studio/Manage-MSSQL-Identity-field-with-tCreateTable/m-p/2326997#M96415 You would have to specify the precision too for INT IDENTITY. Just mention Length = 1 &amp; Precision = 1 which would be Seed &amp; Increment respectively.<BR />Also, you have mentioned db type variables as NCHAR but Talend type as Integer. You need to change them too. Fri, 29 Jun 2018 17:45:52 GMT https://community.qlik.com/t5/Talend-Studio/Manage-MSSQL-Identity-field-with-tCreateTable/m-p/2326997#M96415 iamabhishek 2018-06-29T17:45:52Z https://community.qlik.com/t5/Talend-Studio/Manage-MSSQL-Identity-field-with-tCreateTable/m-p/2326998#M96416 Not logic at all but it work. Thanks ! Mon, 16 Jul 2018 14:37:54 GMT https://community.qlik.com/t5/Talend-Studio/Manage-MSSQL-Identity-field-with-tCreateTable/m-p/2326998#M96416 Anonymous 2018-07-16T14:37:54Z