That is correct, nothing in FTP is encrypted unless vendor/provider encrypts the file before dumping it in FTP site. I don't think any file transfer utility/software automatically encrypts the file during file transfer process. Vendor/provider needs to encrypt it. There are different software that can be used to encrypt the file as well as username and password that taps into FTP site to download it. Once encrypted file is downloaded, you can perform decryption of the file in the SSIS buffer and import it into database table(s). To perform encryption and decryption, you don't need to rely on Pragmatic Work's Task Factory but you do need some other software to encrypt/decrypt. You can use CozyRoc for this purpose.