Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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?