using the SSIS feature of SQL Server to do FTP Transfer, what ports would need to be open between SQL Server and the FTP site?
in one instance, the SQL server (SSIS) will be putting the file into the secured FTP site using id and password. at another time, it will need to read the file from FTP site and bring it down to this side.
what port are needed to be opened? will it be only on the SQL Server?