I am working on a pipeline to pull data from a SQL Server database and insert into a SQLMX database.
I got this pipeline working, but it fails after the first run as it’s trying to insert records that already exist.
My thought was to use a pipeline like the following:
However, the Generic JDBC select from the SQLMX database fails with the following error:
Failure: Failed to execute select query., Reason: SQL [select * from "DEFAULT_SCHEMA"."ASSETS" limit ?]; *** ERROR LIMIT is a reserved word. It must be delimited by double-quotes to be used as an identifier. [2017-09-01 16:42:39], Resolution: Please check sql query.
I have nothing included in the limit clauses.
I am able to use the
Generic JDBC - Execute snap to read from that database / table, but the snap has no head that I can connect with other snaps.