December 18, 2012 at 1:53 pm
Hi..I want to load data from below website for currency rates. I want to get only major currencies.
http://investing.money.msn.com/investments/exchange-rates/
any help will be useful.
thanks
December 18, 2012 at 2:08 pm
kick_12309 (12/18/2012)
Hi..I want to load data from below website for currency rates. I want to get only major currencies.
If you want to run this in SSIS, I think you're going to have to use the Script Task transformation and write some .Net code to do screen scraping. Sorry, I've never done this. But Bing/Google for some ideas.
HTH,
Rob
December 18, 2012 at 2:51 pm
Does it have a rss stream or are you scraping the data off the page? What format are you getting it in?
Usually sites like that have the ability to request an XML document from them, which makes life a lot easier.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply