Hi everybody, I'm sorry to create a new post but I can't find an answer to my problem. I have a tMSSqlInput with a query. When I run the query I have the following error message: "Exception in component tMSSqlInput_5 java.sql.SQLException: The executeQuery method must return a result set. at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:488) at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304) (...)" However if I run my query with Microsoft Sql Server Management Studio I get my results so, i don't know what to do... If someone can help me i'll be great!! Thanks!!
It seems that the SQL statement in tMSSqlInput_5 is an action (e.g. UPDATE, DELETE, INSERT) and not a SELECT query. To perform direct actions statements you should use tMSSqlRow.
