SSIS FTP Passive Mode

SSIS and Import/Export
1

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.

image
image864×1019 37.4 KB

2

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: