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 |
|
321dutch
Starting Member
2 Posts |
 Posted - 2008-02-18 : 10:59:56
|
| A friend asked me if it was possible to write a SQL script that will go to a website, enter a username/password, click a few buttons and download a file on a daily basis. I told him I do not know of a way to do that but that if he could have the supplier of the file post it on an ftp site then I could write a batch file that downloads the file and a nightly job to call the batch script.Does anyone know how to do what he was asking, that is, write a script (sql or other) that navigates a web site?Any help given would be greatly appreciated. Thanx. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-18 : 11:04:08
|
| Yes you can do that by writing script in Automated Testing software like Rational Robot, but not possible through SQL.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
Qualis
Posting Yak Master
145 Posts |
Posted - 2008-02-18 : 11:54:40
|
| You can use SSIS and drop a Script Task onto the ControlFlow to access the website. You'll have to use VB.Net. |
|
|
|
Qualis
Posting Yak Master
145 Posts |
Posted - 2008-02-18 : 11:55:18
|
| You can also do this with DTS and an ActiveX Script task. (forgot I was in the SQL Server 2000 forum!) |
|
|
|
|
|
|
Navigate webpage