Hi, I'm trying to do a fairly simple ETL job, but the problem is that the table I want to write to is stored in an Oracle schema which contains a "-": "DB-SCHEMA" (example).
Now the tOracleOutput generates this: INSERT INTO DB-SCHEMA.TEST (TESTCOLUMN) VALUES ('record1') which causes an error (ORA-00926. 00000 - "missing VALUES keyword") Because the correct statement would be this: INSERT INTO "DB-SCHEMA".TEST (TESTCOLUMN) VALUES ('record1') does anybody know how I can either make sure there are quotes around the schema name, or the statement is generated without the schema prefix?
