Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

Aluminum

Programmer
Jun 8, 2007
41
US
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?
 
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?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top