https://community.qlik.com/t5/Talend-Studio/Ignore-auto-increment-field/m-p/2345015#M112597 <P>This is relatively straight forward, but hidden. You need to go to the Advanced settings of your database component and select "Use field options". You will then see all of your columns. Just untick the insert and update ticks next to your autoincrement&nbsp; column. Then you are done <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 31 May 2019 09:44:17 GMT Anonymous 2019-05-31T09:44:17Z https://community.qlik.com/t5/Talend-Studio/Ignore-auto-increment-field/m-p/2345014#M112596 <P>I have a csv file that needs to be inserted to a MSSQL table, however the table has an auto increment ID field that is set to auto generate a number, how to ignore it during the insertion phase, as I'm getting an error even though I'm leaving it as blank field. Should I remove the column from the DBoutput?</P> <P>&nbsp;</P> <P>Any help would be appreciated.</P> Fri, 31 May 2019 08:36:13 GMT https://community.qlik.com/t5/Talend-Studio/Ignore-auto-increment-field/m-p/2345014#M112596 Moe1 2019-05-31T08:36:13Z https://community.qlik.com/t5/Talend-Studio/Ignore-auto-increment-field/m-p/2345015#M112597 <P>This is relatively straight forward, but hidden. You need to go to the Advanced settings of your database component and select "Use field options". You will then see all of your columns. Just untick the insert and update ticks next to your autoincrement&nbsp; column. Then you are done <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 31 May 2019 09:44:17 GMT https://community.qlik.com/t5/Talend-Studio/Ignore-auto-increment-field/m-p/2345015#M112597 Anonymous 2019-05-31T09:44:17Z