https://community.qlik.com/t5/Talend-Studio/getting-exception-during-transformation/m-p/2281191#M55804 <P><A href="https://community.qlik.com/s/profile/0053p000007LREZAA4">@hurleigh</A>&nbsp;, you cannot convert into BIGDECIMAL ,may be you need to use Long or Double in the data type of tmssqlinput.</P> Thu, 28 May 2020 13:13:06 GMT manodwhb 2020-05-28T13:13:06Z https://community.qlik.com/t5/Talend-Studio/getting-exception-during-transformation/m-p/2281190#M55803 <P>Exception in component tMSSqlInput_1</P><P>java.sql.SQLException: The value supplied cannot be converted to DECIMAL.</P><P>at net.sourceforge.jtds.jdbc.Support.convert(Support.java:653)</P><P>at net.sourceforge.jtds.jdbc.JtdsResultSet.getBigDecimal(JtdsResultSet.java:1024)</P><P></P><P></P><P>my input data contain 3 columns with value :</P><P>16179.96 161.80 16018.16</P><P>-2922.73 0.00 -2922.73</P><P>-6.00 0.00 -6.00</P><P>385.60 0.00 385.60</P><P>30131.38 0.00 30131.38</P><P>&nbsp;</P><P>transformation from sqlserver to sqlserver in sqlserver DB schema is Numeric but during importing data while during transformation we are taking BigDecimal as data type in Type on tmysqlinput and DBType in Numeric</P><P>Any help appreciated</P><P></P><P></P><P>lots of hardcore big-boob fucking videos here <A href="https://bigtitstube.xxx/" target="_blank">https://bigtitstube.xxx/</A></P> Sat, 16 Nov 2024 02:18:00 GMT https://community.qlik.com/t5/Talend-Studio/getting-exception-during-transformation/m-p/2281190#M55803 Anonymous 2024-11-16T02:18:00Z https://community.qlik.com/t5/Talend-Studio/getting-exception-during-transformation/m-p/2281191#M55804 <P><A href="https://community.qlik.com/s/profile/0053p000007LREZAA4">@hurleigh</A>&nbsp;, you cannot convert into BIGDECIMAL ,may be you need to use Long or Double in the data type of tmssqlinput.</P> Thu, 28 May 2020 13:13:06 GMT https://community.qlik.com/t5/Talend-Studio/getting-exception-during-transformation/m-p/2281191#M55804 manodwhb 2020-05-28T13:13:06Z