[resolved] using bulk load with talend

[Anonymous]

Hi 
please help me I'm so blocked 
i have 8 files format .txt  and each file has a 1GB like a size , my mission is to load this 8 fiels into an oracle table 
i use the component tfilelist, tfileinputdelimited and toracleoutputbulkexec but it does'nt work 
because the .ctl file generated by toracleouputbulkexec make the colums of the table between double cotes 
so how can i do this there is any solution for my problem 
how can i load the 8 files which are so big into a oracle table using sql loader 
pleaase help me 
Thanks

[Anonymous · Accepted solution]

I suggest use tOracleBulkExec component instead.  

[Anonymous]

Thanks Mike-West for your reply 
can you explain to me how i use toraclebulkexec and how you make the ctl file 
and you make for all the files 
Thanks

[Anonymous]

tOracleBulkExec component simply loads a file using sql*ldr.   It will create the .ctl file for you based on the schema.  It also has an option for you to supply your own control file in advanced settings "use existing ctl file" if you prefer.

[Anonymous]

hi all,
here's the scenario from Talend help :
https://help.talend.com/search/all?query=tOracleBulkExec&content-lang=en
... or press F1 from your studio to got some quick help
regards
laurent