I have an ETL model to download CSV files from the SFTP server into my local directory. Usually I'm using FileZilla and I log in to the SFTP server using the username that directs me into /home/username. The problem is, my CSV file is on its parent folder so I need to click on ".." 2 times before I can access the file. And now every time I run my ETL model, it always shows an error like this on tFTPFileList
Exception in component tFTPFileList_1 (PLISKUMasterDataV2)
java.lang.NullPointerException
at testingsftptodatabase.pliskumasterdatav2_0_3.PLISKUMasterDataV2.tFTPFileList_1Process(PLISKUMasterDataV2.java:1375)
at testingsftptodatabase.pliskumasterdatav2_0_3.PLISKUMasterDataV2.tFTPConnection_1Process(PLISKUMasterDataV2.java:1164)
at testingsftptodatabase.pliskumasterdatav2_0_3.PLISKUMasterDataV2.tDBConnection_2Process(PLISKUMasterDataV2.java:896)
at testingsftptodatabase.pliskumasterdatav2_0_3.PLISKUMasterDataV2.runJobInTOS(PLISKUMasterDataV2.java:11073)
at testingsftptodatabase.pliskumasterdatav2_0_3.PLISKUMasterDataV2.main(PLISKUMasterDataV2.java:10829)
I assume it's because of the path that I put tFTPFileLIst. What should I do to move to the parent folders first before getting the CSV data? This is my model right now
question from:
https://stackoverflow.com/questions/65903066/how-to-access-parent-folder-with-tftpfilelist-on-talend 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…