Hello...

I want to log into a FTP server using DTS and find the latest file sitting
on the FTP server. Then I want to download it to a specific directory. I
am using SQL Server 2000. I am able to use the FTP task in DTS... but with
that I have to manually find and select the new file I want to bring over.
Is there a way I can programmatically do that? If so... are there any
examples I can go to or see?

Please advise...

Cheers!

Brett

Brett,

If the file names are standardized (file20040723 today, file20040724
tomorrow) you could do this by generating the next file name into a
Global Variable using an ActiveX script and then using a Dynamic
Properties Task to set the new file name in you FTP task.

If the file name cannot be predicted I would consider using an FTP
Program that lets you synchronize directories (I know that WS_FTP Pro
does this), and using that to move the files. Perhaps someone else
here can recommend a way to do this using DTS.

Wes

Brett Davis wrote: