Skip to main content
Announcements
New: No-code data prep in Qlik Cloud Analytics™ TAKE A TOUR
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

"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]

Labels (2)
1 Solution

Accepted Solutions
Not applicable
Author

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?


 

View solution in original post

2 Replies
manodwhb
Champion II
Champion II

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

Not applicable
Author

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?