"Data truncation error unable to insert first row into DB

Six Stars

"Data truncation error unable to insert first row into DB

hi,

          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

 

statistics] connected
Data truncation
[ERROR]: testgis.chambaljob_0_1.chambaljob - tMSSqlOutput_1 - Data truncation
[statistics] disconnected
Job chambaljob ended at 12:50 16/04/2018. [exit code=0]


Accepted Solutions
Six Stars

Re: "Data truncation error unable to insert first row into DB

the problem get solved earlier . thank you


@manodwhbwrote:

what is the coulmn name and can you chek the data typpes of input and ouput column?


 


All Replies
Thirteen Stars

Re: "Data truncation error unable to insert first row into DB

what is the coulmn name and can you chek the data typpes of input and ouput column?

Manohar B
Six Stars

Re: "Data truncation error unable to insert first row into DB

the problem get solved earlier . thank you


@manodwhbwrote:

what is the coulmn name and can you chek the data typpes of input and ouput column?


 

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.