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

[Steve_F]

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:

1. String ctlf_tDBBulkExec_1 = dataf_tDBBulkExec_1 + ".ctl";
2. String badf_tDBBulkExec_1 = dataf_tDBBulkExec_1 + ".bad";
3. String dscf_tDBBulkExec_1 = dataf_tDBBulkExec_1 + ".dsc";
4. 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!