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 |
|
testhousing
Starting Member
2 Posts |
 Posted - 2009-06-04 : 12:41:09
|
| How to call an asp page in SSIS Package? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-04 : 13:21:06
|
| whats the purpose of doing that? |
 |
|
|
testhousing
Starting Member
2 Posts |
Posted - 2009-06-04 : 18:38:36
|
| we want to call a asp page from one server in another server.To do that, we planned to use ssis package web service task, but could not able to figure how to call a web page using web service task or any other tasks in ssis package |
|
|
|
mdgraves
Starting Member
1 Post |
Posted - 2012-02-08 : 16:04:56
|
quote:
Originally posted by testhousing
we want to call a asp page from one server in another server.To do that, we planned to use ssis package web service task, but could not able to figure how to call a web page using web service task or any other tasks in ssis package
Were you/anyone able to figure out how to call ASP page from SSIS? We want to use this method to periodically call all of our SSRS servers (the ASP page loaded on each) to keep the service awake and to also verify SSRS is working (our's crashes every now and then, and better to proactive catch than users calling in cases....).Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-08 : 16:17:54
|
quote:
Originally posted by mdgraves
quote:
Originally posted by testhousing
we want to call a asp page from one server in another server.To do that, we planned to use ssis package web service task, but could not able to figure how to call a web page using web service task or any other tasks in ssis package
Were you/anyone able to figure out how to call ASP page from SSIS? We want to use this method to periodically call all of our SSRS servers (the ASP page loaded on each) to keep the service awake and to also verify SSRS is working (our's crashes every now and then, and better to proactive catch than users calling in cases....).Thanks.
for that purpose why do you need to use SSIS?Wont a subscription or a sql agent job to execute and render the report url suffice? it can even be configured to log details to control table which can be monitored for the issues------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Calling Asp page in SSIS Packages