https://community.qlik.com/t5/Talend-Studio/quot-Data-truncation-error-unable-to-insert-first-row-into-DB/m-p/2370586#M133613 <P>hi,</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; i tried to insert data in excel file to MSSQL datbase, all the data get moved to the db , but the first row not get moved into db also showing this error</P> <P>&nbsp;</P> <P>statistics] connected<BR />Data truncation<BR />[ERROR]: testgis.chambaljob_0_1.chambaljob - tMSSqlOutput_1 - Data truncation<BR />[statistics] disconnected<BR />Job chambaljob ended at 12:50 16/04/2018. [exit code=0]</P> Mon, 16 Apr 2018 08:24:30 GMT 2018-04-16T08:24:30Z https://community.qlik.com/t5/Talend-Studio/quot-Data-truncation-error-unable-to-insert-first-row-into-DB/m-p/2370586#M133613 <P>hi,</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; i tried to insert data in excel file to MSSQL datbase, all the data get moved to the db , but the first row not get moved into db also showing this error</P> <P>&nbsp;</P> <P>statistics] connected<BR />Data truncation<BR />[ERROR]: testgis.chambaljob_0_1.chambaljob - tMSSqlOutput_1 - Data truncation<BR />[statistics] disconnected<BR />Job chambaljob ended at 12:50 16/04/2018. [exit code=0]</P> Mon, 16 Apr 2018 08:24:30 GMT https://community.qlik.com/t5/Talend-Studio/quot-Data-truncation-error-unable-to-insert-first-row-into-DB/m-p/2370586#M133613 2018-04-16T08:24:30Z https://community.qlik.com/t5/Talend-Studio/quot-Data-truncation-error-unable-to-insert-first-row-into-DB/m-p/2370587#M133614 <P>what is the coulmn name and can you chek the data typpes of input and ouput column?</P> Mon, 16 Apr 2018 11:42:31 GMT https://community.qlik.com/t5/Talend-Studio/quot-Data-truncation-error-unable-to-insert-first-row-into-DB/m-p/2370587#M133614 manodwhb 2018-04-16T11:42:31Z https://community.qlik.com/t5/Talend-Studio/quot-Data-truncation-error-unable-to-insert-first-row-into-DB/m-p/2370588#M133615 <P>the problem get solved earlier . thank you</P> <BLOCKQUOTE> <HR /> <A href="https://community.qlik.com/s/profile/0053p000007LKmJAAW">@manodwhb</A>wrote: <BR /> <P>what is the coulmn name and can you chek the data typpes of input and ouput column?</P> <HR /> </BLOCKQUOTE> <P>&nbsp;</P> Mon, 16 Apr 2018 12:37:30 GMT https://community.qlik.com/t5/Talend-Studio/quot-Data-truncation-error-unable-to-insert-first-row-into-DB/m-p/2370588#M133615 2018-04-16T12:37:30Z