Setting the ftp file name

#1

Does anyone know an easy way to get the name of the last file dropped on an
ftp site and then specifying the MS SQL ftp Task to retrieve the file? I
assume this will be done using a lot of VB and I'm not proficient with VB.

#2

This is isn't possible using the FTP Task, as there is no way to enumerate
remote files. I would probably use ftp.exe and the mget command for
simplicity.

--
Darren Green
http://www.sqldts.com

"1erbee" <pretoriasux (AT) webmail (DOT) co.za> wrote

Quote:

Does anyone know an easy way to get the name of the last file dropped on
an
ftp site and then specifying the MS SQL ftp Task to retrieve the file? I
assume this will be done using a lot of VB and I'm not proficient with VB.

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

Setting the ftp file name

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

Setting the ftp file name - 02-19-2004 , 03:46 AM

Re: Setting the ftp file name - 02-19-2004 , 04:43 AM