I am trying to create an SSIS package that will access an SFTP site. SSIS has an FTP task but no SFTP. I read online that SSIS does not support SFTP directly. Has anyone ever set up SFTP in SSIS? If yes how did you do it? I am new to SSIS so I am learning by doing.
Otherwise you install FileZilla or some other sftp client and then you use command tasks or script tasks however you feel comfortable to then go and execute the command line version of FileZilla to perform the transfer.