jetlounge

Got the connectionstring and credentials down pat, and no error message when executing a SQL Server Agent Job that included an FTP task. 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.

1. 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

2. 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