Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    2

    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.

    Any ideas please ?

  2. #2
    Join Date
    Mar 2008
    Posts
    2
    Update:

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •