Can the FTP task in SQL Data Transformation Services be configured to connect to SSL? I'm trying to connect to an SSL site and an error comes up regarding connection not being allowed. Any ideas from anyone on this?
Note If you experience a problem using the FTP task, use http://ftp.exe in a command prompt to help identify the problem, as both the FTP task and http://ftp.exe use the same connection method.