Hi, Nicholas,

Yup, the SSIS FTP control is pretty bare-boned and doesn't support Secure FTP. Some of SSIS control flow tasks are good and some (FTP and Email) are a bit weak.


At the risk of just providing links and nothing else, here are a couple of URLs that discuss some ways to do it:

http://www.sqlservercentral.com/Forums/Topic366150-148-1.aspx

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/fdace86e-1238-4f05-85b1-bce5ba74a4ac/how-to-secure-transport-of-file-to-ftp-server-from-ssisoptions

http://prashantbaker.blogspot.com/2008/01/how-to-use-sftp-with-ssis-packages.html