Unanswered: SQL DTS to access a secure web page and retrieve file
Ok, here is the problem.
SQL Server 2000 DTS Package
Need to access a secure website which displays a list of available files for download.
Firstly need to read that page to determine the most recent file.
There is a view link to the file which uses java script to post back information for file download.
Ok, i can get the SQL DTS to goto the site and pull back the list of files. So what i need to understand is how to call a java function within the page passing a parameter I now know what the value is to the page and get it to save the file it relates to.