DBInsert Passing Null Records
I have a process that’s been in place for months that uses DBInsert to load records into an Oracle global temp table that are then inserted into a production table. Once DBInsert has run it shows a “1” insert status for each record, which can be seen in the Input Data with Insert Status output.
However, if I query the temp table it has nothing in it, which has never happened before, and therefore is passing null records to the production table which is failing as a result. It’s configured to cache tables in memory, so I tried using “writes tables to disc”, but the same thing is happening. It recognizes the schema and table and isn’t returning an error, so why isn’t it loading the temp table?