How to write rows into MS SQL DB? (Error: IDENTITY_INSERT is set to off)

Hi,

I have a JSON with some 250’000 lines and I would like to write some of the data into a data base.

I was able to parse all the needed data, but now, I am struggling to write it into my MS SQL DB. The connection seems to be fine, but there is an issue with the RowID?

I don’t need the KNIME-RowID, as the DB itself will generate an ID and I have my own unique identifier…

Questions:

• Which node should I take to write rows into a MS SQL DB?

• How can I only write my columns, without the RowID?

This is KNIME version 5.9.0.

Thank you for your help,

Chris