sql server ftp - needed ports opened in windows server 2008R2

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?
LVL 5
25112Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AlexPaceCommented:
FTP servers are usually configured to use port 21 for the control channel... The control channel is where you authenticate and send commands.  FTP uses a second connection known as the "data channel" and it is typically a port above 1024 and the exact number is negotiated during the FTP session immediately before it is used.  If the server supports Passive Mode data channels then the server's administrator should be able to tell you a port range used for this type of connection... then you give that to your firewall guy and tell him you need to make outbound connections to the FTP server on that port range.

If the FTP server only supports active mode then your firewall needs to allow inbound connections from the FTP server.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Routers

From novice to tech pro — start learning today.