I have problem of memory with talend, in fact when I run the job , I have this error:
Exception in component tFileOutputExcel_1
java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML stream
Is there a zero byte version of that file by any chance? I have seen similar issues when you try to append to an Excel file which appears to be there but isn't in reality an Excel file.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.