March 7, 2012 at 3:39 am
Can anyone help?
January 15, 2018 at 6:33 am
KWD
January 15, 2018 at 1:47 pm
The documentation for the command-line FTP in Windows does not show a parameter to specify passive mode.
You can set passive mode operation on an FTP task in an SSIS package,
You could use an FTP_Client object in .Net code in a CLR procedure.
cURL can be used to add more bells and whistles to an FTP script, and supports passive-mode http://FTP. This would still be called via xp_cmdshell.
January 16, 2018 at 4:49 pm
I would highly recommend using the command line version of WinSCP, called WinSCP.com. It works great, can handle "passive mode", and SFTP and is also freely available.
January 16, 2018 at 5:39 pm
Paul Bukowski - Tuesday, January 16, 2018 4:49 PMI would highly recommend using the command line version of WinSCP, called WinSCP.com. It works great, can handle "passive mode", and SFTP and is also freely available.
I agree. Using SQL script to do FTP job is not the right way to go. It seems that you are trying to delete a file once downloaded. Powershell can do a much better job. In fact, you didn't need to delete the source file. You should move it to a 'downloaded' or'archive' folder on the FTP server just in case you need to download it again.
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply