One Star

Length or precision specification 0 is invalid.

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.
2 REPLIES
Six Stars JR
Six Stars

Re: Length or precision specification 0 is invalid.

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.
Moderator

Re: Length or precision specification 0 is invalid.

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.