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 |
|
leahsmart
Posting Yak Master
133 Posts |
 Posted - 2006-01-23 : 11:30:24
|
| Hello.Is it possible for a DTS to call an asp page? I currently have a page which produces a report, this report is accessed by our users though our site. Recently someone has decided that scheduling these reports and sending them out attached to an email would be great. I would like to use the DTS to run the scheduled reports, but all the code for my reports is on the ASP page. I do not want to have two copies of the code. Would it be possible for the the DTS to run an asp page and return a status saying if the page caused an error?Does anyone have any ideas for what I can do?Leah |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-23 : 12:10:32
|
| You could probably schedule the page using the Windows Scheduler, couldn't you?Maybe a few lines of ASP that "scrape" the actual page in question ... which would cause it to be triggered, at least.Kristen |
 |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-01-23 : 13:07:10
|
Why use DTS?? You could send the emails through ASP maybe?? and scrape the reports through ASP...Corey Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."  |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-23 : 16:08:31
|
quote:
Originally posted by leahsmart
I currently have a page which produces a report, this report is accessed by our users though our site. ... but all the code for my reports is on the ASP page. I do not want to have two copies of the code. Would it be possible for the the DTS to run an asp page and return a status saying if the page caused an error?
>>> Accessed by your users ?>>> Send an email ?yes, you could go ASP, All the way |
|
|
|
|
|
|
Calling an ASP page from a DTS