Alternate FTP client for NT and SQL Server?

[Darin Drewrey]

We just erected a new firewall that only allows PASV FTP. Now, my SQL Server can't call master..xp_cmdshell "ftp ...".

Does anyone know how to make the NT FTP client work in PASV (passive) mode or another FTP client that can be called from xp_cmdshell and works in passive more?

[Ray Miao]

Did you try it in dos prompt on the server? Maybe have to check filters on firewall.


------------
Darin Drewrey at 2/24/00 2:20:05 PM

We just erected a new firewall that only allows PASV FTP. Now, my SQL Server can't call master..xp_cmdshell "ftp ...".

Does anyone know how to make the NT FTP client work in PASV (passive) mode or another FTP client that can be called from xp_cmdshell and works in passive more?