July 4, 2005 at 7:53 am
Does anybody know if it is possible to setup an FTP task that downloads files according to a mask criteria with wild cards e.g. T*.xml ?
July 4, 2005 at 10:27 pm
Depends on what FTP client your are using, Windows XP FTP (command line) supports wildcards in the file name, see XP Help for FTP subcommands, you can use the glob toggle to turn them on or off, they are on by default.
As in:
ftp> mput *.txt
Andy
July 5, 2005 at 7:27 am
You could build a dos batch file using and activex task and then execute it, you'll just need to set a flag to be sure that it does not prompt for every file you download.
user testuser
password
prompt
cd /directory/to/get/files
mget *.XML
bye
July 5, 2005 at 12:45 pm
You can create a stored procedure or activeX script that build an ftp batch file dynamically and then run the ftp command with the s: option from your DTS package.
July 8, 2005 at 3:39 am
Thanks guys, I actually noticed this article on SSC that is pretty much in line with your suggestions
http://www.sqlservercentral.com/columnists/sjones/pushftp.asp
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply