Download All Files in a folder with FTP Task

#1

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
the file, therefore I am unsure of the file name.

#2

In article <08b701c3db22$9ba1a960$a101280a (AT) phx (DOT) gbl>, "Jody Kelsch" <jody (AT) mailsuite (DOT) com> wrote:

Quote:

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
the file, therefore I am unsure of the file name.

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Download All Files in a folder with FTP Task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Download All Files in a folder with FTP Task - 01-14-2004 , 10:46 PM

Re: Download All Files in a folder with FTP Task - 01-14-2004 , 11:25 PM