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.
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.
Hi, Split this topic to a new one. @midhun123 how did you set the schema fortMSSqlOutput component? Screenshots will be preferred. Best regards Sabrina
