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(
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(
at text1.flatloading_0_1.FlatLoading.tFileInputDelimited_1Process(
at text1.flatloading_0_1.FlatLoading.runJobInTOS(
at text1.flatloading_0_1.FlatLoading.main(
Job FlatLoading ended at 11:28 23/11/2016.
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.

Re: Length or precision specification 0 is invalid.

Split this topic to a new one.
@midhun123 how did you set the schema for tMSSqlOutput component? Screenshots will be preferred.
Best regards
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.