[CR #575891] For the DB Bulk Load Sybase IQ component, when the Upsert function is processed, the DELETE operation succeeds, but the INSERT operation fails because of a datatype conversion error in one of the columns being inserted. If you select “Execute post-processing for successful execution” to commit the transaction, the unsuccessful INSERT operation is not committed. The original row that was supposed to have been updated is deleted from the table.
Workaround: Select “Execute post-processing for failed execution” to roll back the Delete operation and to reset the table to its original state.
