Post reply

Retreiving a file via HTTP with DTS

  • February 7, 2002 at 1:49 am

    #104611

    Is it possible to retrieve a file from a website via HTTP with DTS? I would like to get the following exchange rate data from a website and pump it into a table. Here is the URL for the example data:

    http://www.oanda.com/cgi-bin/fxcsv/fxcsv?client_id=oandatest&expr=CHF

    Thanks!

    Jay

  • February 7, 2002 at 4:17 am

    #423383

    I have not seen a way to do this tpe of URL directly in SQL DTS, however I have written a VB app using the IE component to navigate to a page and pick the text off, I can send you example code, then you could execute the App which can do the work and shut itself down after done. One thing of note though, for some reason occasionally the navigate process will not occurr on our network here, it just hangs, but I have not been able to produce elsewhere or find an underlying reason why.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply