Hi experts,
I m new to Talend. I m currently working on the DW project. Through online tutorial I have learnt how to do mapping using tmap. I need to insert data from the mssql table to another mssql table. From source only four columns need to be inserted into the target table. All are varchar columns. First tried to view the data of the source through tLogRow, while execution I m getting the below error
Exception in component tMSSqlInput_1
java.sql.SQLException: The value supplied cannot be converted to INTEGER.
at net.sourceforge.jtds.jdbc.Support.convert(Support.java:653)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getInt(JtdsResultSet.java:641)
at edw.psp_dim_0_1.PSP_DIM.tMSSqlInput_1Process(PSP_DIM.java:778)
at edw.psp_dim_0_1.PSP_DIM.runJobInTOS(PSP_DIM.java:1268)
at edw.psp_dim_0_1.PSP_DIM.main(PSP_DIM.java:1136)
As there are no integer column, I could find why this error has occurred. Kindly do the needful. I have attached the screenshot for further use.
Thanks
Siva