[resolved] insert data into MS Sql server

[Anonymous]

Hello!
I get the follow error on trying to insert data into MS Sql Server

Exception in component tMSSqlOutput_1
java.sql.SQLException: Line 1: Length or precision specification 0 is invalid.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)

What is wrong?
Could you help me plese?
Gisella

[Anonymous]

Check that the schema which is in use for the tMSSQLOutput_1 component has the appropriate data lengths included for all fields (under edit schema in the component).
I believe the lengths need to be included as part of the schema for validation purposes.

[Anonymous · Accepted solution]

Ok resolved!
See this topic
https://community.talend.com/t5/Design-and-Development/resolved-Metadata-Schema-quot-Guess-quot-ing-...