Plaiiiiise i need you help, I have a FTP server that contain five file csv, and i need to extract this file into talend ETL in order to put them into mysql database,
this my job :
FTP connection -->tftpfile list-->tftpget-->tfiledelimeted
i get an error at tftpfilelist and i dont know where is the problem ( Démarrage du job achatFTp a 08:55 08/05/2017.
[statistics] connecting to socket on port 3990
Exception in component tFTPFileList_1
Job achatFTp terminé à 08:55 08/05/2017. [Code sortie=1])
This is difficult to help with since we cannot see your setup. But first of all, have you tried simply"getting" the file first? You should approach this by first getting the file and then reading it once it is down. I suspect that you cannot get the file because of your FTP settings. Are you using ascii or binary transfer mode? Have you tried changing this setting (this is a common reason for failure). Also, are you using SFTP or FTP? Does your user actually have permissions to access the location? Can you access it using another FTP client?
thank you for your reply, i use ASCII not binary,
yes i try the tftpget only at the first,
I think you are right, i have just the read only in the C:\ FTP where i put the remot directory, I Use the NTFS repartition,
i will try now to convert the NTFS into FAT32 and i will till you if that works with me