One Star

load data from a file to oracle table using bulk exec

hi talend pro
i have a problem i use tfileinputdelimited --> toracleoutputbulkexec
but it does'nt work
because this error : java.io.FileNotFoundException: C:\out.csv (Access is denied)
i need help please can you show me how i do the bulk load from a file to a oracle table
and thanks for your great help
5 REPLIES
Seventeen Stars

Re: load data from a file to oracle table using bulk exec

hi,
as message tell you : you don't have permission to write in C:/ .
choose another location.
regards
laurent
Four Stars

Re: load data from a file to oracle table using bulk exec

Whether the metadata is created for input file?
Error says that the file is not generated based on input file.. Whether the file exists in the c:\?
vaibhav
One Star

Re: load data from a file to oracle table using bulk exec

Thanks laurent for your reply
but what's the problem with the c:/ i don't think so
Thanks vaibhav for your reply , can you explain to me how can i do this becaue there is a file which his path in the file name generated by the same data of my tfileinputdelimited ? and what should i do
thanks for your help
Seventeen Stars

Re: load data from a file to oracle table using bulk exec

could you try to bulk your data with OracleBulk + OracleExec (do the same think that OutputBulkExec but using 2 components)
Also try to write a simple flat file in c:\ (just a test Smiley Happy
regards
One Star

Re: load data from a file to oracle table using bulk exec

Thanks kzone for your help
i try of course with toracleoutputbulk and toraclebulkexec
then if i met in the file name of the component toracleoutputbulk the path of my tfileinputdelimited
this componenent writes data in the same data
and if i met a new path i have this error :Exception in component tOracleOutputBulk_1
java.io.FileNotFoundException: C:\out.csv (Access is denied)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(Unknown Source)
at java.io.FileOutputStream.<init>(Unknown Source)
can you show me by example how i do this and thanks