How to set CTL/BAD/LOG file name and location for tDBBulkExec (oracle)?

Steve_F — Sat, 16 Nov 2024 00:17:18 GMT

Hey All!

I am setting up a tDBBulkExec (oracle) component and it's working fine, however, I'd like to set up a few of the SQLLDR file locations and names i.e ctl/bad/log files and I can't seem to figure out how to do this from the designer.

For example, I want to store all the log files in C:\temp\context.var.log for instance.

I can see this is how they are defined within the code itself, but I am hesitant to touch those:

String ctlf_tDBBulkExec_1 = dataf_tDBBulkExec_1 + ".ctl";
String badf_tDBBulkExec_1 = dataf_tDBBulkExec_1 + ".bad";
String dscf_tDBBulkExec_1 = dataf_tDBBulkExec_1 + ".dsc";
String logf_tDBBulkExec_1 = dataf_tDBBulkExec_1 + ".log";

It is also possible to automatically remove any of these files after the process has completed?

Cheers!

topic How to set CTL/BAD/LOG file name and location for tDBBulkExec (oracle)? in Talend Studio

How to set CTL/BAD/LOG file name and location for tDBBulkExec (oracle)?