Extract webpage source with tsql

Question

Hi,

I hope that I've hit the right forum.

I need to get the source of a webpage like:

http://www.google.com/finance/historical?q=INDEXNASDAQ%3AOMXC20&ei=H2X6ULjSFoiOwAP86gE

into a varchar() to be able to update a table with some of the values. Do we have an easy way to extract the source of a website with T-sql ?

If not should I consider writing an CLR ?

Answer 1

T SQL is not meant to do such operations, you should ideally use CLR or SSIS packages which call a process task which will get webpage source for you.

---

Jayanth Kurup - www.enabledbusiness.com