Building the Job
Procedure
- Drop the following components: tOracleInput, tFileOutputDelimited and tOracleBulkExec from the Palette to the design workspace.
- Connect the tOracleInput to the tFileOutputDelimited using a Row > Main link.
- Connect the tOracleInput to the tOracleBulkExec using a OnSubjobOk trigger link.