I'm trying to insert data into a SQL Server DB with a Database Writer node and i get this error:
An explicit value for the identity column in table <tablename> can only be specified when a column list is used and IDENTITY_INSERT is ON.
I set IDENTITY_INSERT ON but it still doesn't work. It seems that the DB writer node constructs this query:
INSERT INTO <tablename> (value1,value2)
While the server expects:
INSERT INTO <tablename> (column1,column2) VALUES (value1, value2)
Is there a way to constructs manual Insert statement in KNIME?