While attempting to ETL a SalesForce object from SalesForce to Microsoft SQL Server using Talend 5.2.0 the following error presented:

[statistics] connected
Exception in component tMSSqlOutput_2
java.sql.SQLException: Line 1: Length or precision specification 0 is invalid.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
    at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
    at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160)
    at general_etl.servicemax_0_1.ServiceMax.tSalesforceInput_2Process(ServiceMax.java:6198)
    at general_etl.servicemax_0_1.ServiceMax.runJobInTOS(ServiceMax.java:9086)
    at general_etl.servicemax_0_1.ServiceMax.main(ServiceMax.java:8939)
[statistics] disconnected

The issue seems to be caused by columns that are identified as the ‘float’ datatype. Opening the Microsoft SQL destination table properties, and definiting a data length for each column that was a ‘float’ cleared up the problem.