Using MS SQL Server, I have a KNIME workflow that creates some large tables from a file aggregation / import. I was attempting to uise the Database SQL Executer node to index the tables after they are created but it is not processing the SQL succesfully. From SSMS the syntax and execution are acceptable. Does the SQL Executor node omit execution of create / drop commands? I did not see any other nodes suitable to execute this task. Any advice in this regard? Thanks
I was able to resolve this, the SQL Executer does not like multiple statements separated with GO statements. Once they were omitted this is functioning as expected. Thanks.
Glad you got that working. Thanks for the update.