Retreiving a file via HTTP with DTS

• jsqldba

  SSChampion

  Points: 11257

  More actions

  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

• Antares686

  SSC Guru

  Points: 125444

  More actions

  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.