SQLTeam.com | Weblogs | Forums

SSIS FTP Passive Mode

We have a FTP server and I think I have configured it correctly because from the client side, I am able to use Filezilla to upload/download data files back and forth.

However, I am not able to get the FTP Task control in SSIS to work. It keeps giving me this message which I am not sure where I need to fix it.

For those who run into this, the solution is to put the public IP Address into the firewall entry of IIS. Make sure to apply and restart the FTP site.

If you don't know your public IP Address, use this: