Got the connectionstring and credentials down pat, and no error message when executing a SQL Server Agent Job that included an FTP task in SSIS. It just sat there, and sat there.
Looked and smelled like a firewall issue. And it was. Didn’t occur in Visual Studio, just when running in automated mode.
To fix (on Windows Server 2008), follw instructions for:
Using Windows Firewall with non-secure FTP traffic
Open a command prompt: click Start, then All Programs, then Accessories, then Command Prompt.
- To open port 21 on the firewall, type the following syntax then hit enter:
netsh advfirewall firewall add rule name="FTP (non-SSL)" action=allow protocol=TCP dir=in localport=21
To enable stateful FTP filtering that will dynamically open ports for data connections, type the following syntax then hit enter:
netsh advfirewall set global StatefulFtp enable
Was this tip useful? Check out SummitCloud solutions to find out what we do!
