SQL Server insert

KNIME Analytics Platform
1

Hi,

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?

Julien

2

Unfortunately not (yet). You can only build custom queries but not inserts. We will try to fix this problem for 2.10.