topic Re: Length or precision specification 0 is invalid. in Talend Studio

Length or precision specification 0 is invalid.

Anonymous — Wed, 23 Nov 2016 17:28:59 GMT

Hi I am issues when loading txt file to MS sql database please help
Exception in component tMSSqlOutput_3
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 text1.flatloading_0_1.FlatLoading.tFileInputDelimited_1Process(FlatLoading.java:885)
at text1.flatloading_0_1.FlatLoading.runJobInTOS(FlatLoading.java:1823)
at text1.flatloading_0_1.FlatLoading.main(FlatLoading.java:1680)
disconnected
Job FlatLoading ended at 11:28 23/11/2016.

Re: Length or precision specification 0 is invalid.

JR1 — Wed, 23 Nov 2016 19:14:46 GMT

You will have to provide "Length" (character columns) and "Length" and "Precision" (numeric columns) in the schema of tMSSqlOutput. I assume you have "0" as "Length" somewhere in there, correct?

And by the way: in the future please create a new issue. There is no real benefit in adding new questions to long resolved issues.

Re: Length or precision specification 0 is invalid.

Anonymous — Thu, 24 Nov 2016 06:50:27 GMT

Hi,
Split this topic to a new one.
@midhun123 how did you set the schema for tMSSqlOutput component? Screenshots will be preferred.
Best regards
Sabrina