How to access parent folder with tFTPFileList

[hilmandenis]

Hello everyone,

I have an ETL model to download CSV files from SFTP server into my local directory. I'm using FileZilla to login and I login to 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. Right now every time I run my model, it always shows an error like this

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

[Anonymous]

Hello,

Is your job successfully connecting to the SFTP server? Are you using FTPS or SFTP? FTPS requires a certificate. SFTP is based on SSH and does not require a certificate.

Best regrds

Sabrina