Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dduplessis
Starting Member
9 Posts |
 Posted - 2011-08-18 : 13:56:43
|
| Hi,Is it possible to connect to a url and load the web-page source from that url, from within T-SQL?Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-18 : 13:59:33
|
| nope. but its possible to do it from sql report if thats what you want. if not, tell what you're trying to exactly achieve------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
dduplessis
Starting Member
9 Posts |
Posted - 2011-08-18 : 14:05:00
|
| I am trying to mine info from a web-page by downloading it, parsing the page source, and filling a table with the mined data. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-18 : 14:10:02
|
| is the page source too complicated? or else it would be worth getting code behind in xml format using some front end language and then passing xml to sql which can parse it and get required info.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
dduplessis
Starting Member
9 Posts |
Posted - 2011-08-18 : 14:27:15
|
| Nope... page source is not complicated. I just really want to find out if it is possible to connect to the URL, and actually get the page source. Kinda like what viewing the page source with your browser would give you. |
|
|
|
dduplessis
Starting Member
9 Posts |
Posted - 2011-08-18 : 14:39:14
|
| basically, I need the C++ equivalent of URLDownloadToFile in TSQL |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-08-19 : 01:12:24
|
| or clr written in C# compilte into sproc or use ssis + script Task using c# to do thatIf you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
Loading Web Page Source from T-SQL