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
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
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
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
regards
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