I would like to use KNIME to write / insert data from one on-premise database to AZURE sql database.
My table has 97 columns.
When I ran the workflow attached , the console showed.
“ERROR DB Writer 3:369 Execute failed: I/O Error: Connection reset”
I had to use Column Filter Node to spilt my table in half ( one has 53 columns, other has 44 ) and the DB writer Node worked.
It seems DB writer can’t write 97 columns.
Is there a limit on the number of columns it can handle or do I miss some configuration?
Could you please suggest how can I write 97 columns at a time.