Download All Files in a folder with FTP Task -- sql server dts

Jody Kelsch
1/14/2004 8:46:58 PM

I have a file that I need to download via ftp. Every time
I need an update the file on the server has a new name.
The file is named with a date (filename040114). Is there a
way to ftp the entire folder contents with the FTP task? I
considered using an INI file with a Dynamic Property Task,
but I am not sure of the exact date the server generated

bb_43 NO[at]SPAM hotmail.com
1/15/2004 5:25:40 AM

[quoted text, click to view]

I don't know if there's a way actually WITHIN DTS, but we have a DTS Task that
calls a Batch file that executes a DOS FTP script.
You can do anything you could do from ftp.exe that way.

sql server dts : Download All Files in a folder with FTP Task