Hi, When execute a new job, i have got the below error message. Please find the attached screen shot. So Please let me know, In which situation the below mentioned error appear. "Starting job bpcateg at 16:57 14/08/2013.
connecting to socket on port 3718 connected Exception in component tMSSqlInput_1 java.sql.SQLException: Incorrect syntax near the keyword 'VALUES'. 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.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304) at migaration.bpcateg_0_1.bpcateg.tMSSqlInput_1Process(bpcateg.java:3595) at migaration.bpcateg_0_1.bpcateg.runJobInTOS(bpcateg.java:7446) at migaration.bpcateg_0_1.bpcateg.main(bpcateg.java:7312) disconnected Job bpcateg ended at 16:57 14/08/2013. " Thanks Siva
hi i am getting error as incorrect syntax near the keyword 'order' but not showing any error symbol on any components.For information order is my target table. can anyone help me out to resolve this issue.
"order" is a SQL key word so, if that is your table name, you need to delimit it with double-quotes. Since double-quotes have a specific meaning for Java (being to delimit a string), you will also need to escape the double-quotes with a back-slash. In the tOutput component, make the table name: "\"order\""