Capture data values from a web page - Possible download the web page

[Aluminum]

I have no idea how to approach this problem I have. Basically, there are four files on a web site. Any time they are replaced with new files, I need to download the files, run an import program and update a table with the new modified dates.

The modified dates are stored on the web site. Is there a way to download the page using DTS? Has anyone had a similar problem?

 

[Aluminum]

This is actually an FTP site. Ideally, I would like to capture the modified date of what displays on the FTP site. If that is not possible, is there any easy way to capture the modified date of a file using active X?

 

[RiverGuy]

SSIS allows you to connect via FTP.

 

[Aluminum]

The page lists out like an FTP site, but is at an HTTP address. I am using sql 2000 DTS and when I try to use the FTP task, it says it cannot connect.

 

[Aluminum]

I think I will just download the page using a batch file with this tool:

http://gnuwin32.sourceforge.net/packages/wget.htm

Then... I can import the Index.html file with DTS, clean it up and evaluate what I need.