Calling an ASP page using DTS - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Calling an ASP page using DTS

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-08-28 : 07:28:57

Steve writes "Hi,

I've read several articles on how to call a DTS package from an ASP page but have not seen any articles on how to use a DTS package to call an ASP page.

I've written an ASP page which updates a database and wanted to create a DTS package which I could schedule hourly to open my ASP page.

Any information would be great!

Thanks
Steve"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-08-28 : 07:29:51

ASP generates HTML to be displayed in a browser. How will DTS use this ?

Damian

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-08-28 : 07:30:57

And who will close the browser window?

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-08-28 : 07:31:04

Or to answer a better question that you didn't ask.
You would be better off putting that functionality into some VBScript and calling that instead.

Damian

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-08-28 : 07:52:11

set h=createobject("microsoft.xmlhttp")
h.open "post", "yourURL", 1
h.send

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-08-28 : 08:01:45

quote:
ASP generates HTML to be displayed in a browser.

Oh, Damian,
it's not necessary in some sense.

<%@ language="vbscript" %>
<%
dim k
k=5
%>

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-08-28 : 20:13:15

ASP/ASP.NET ---> COM / WEB SERVICE -----> STORED PROC/DTS/UDF

DTS ---> STORED PROC

That would we the proper way to do it.

The stored proc's would be your reusable component.

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-08-28 : 20:32:16

quote:
Originally posted by Stoad

set h=createobject("microsoft.xmlhttp")
h.open "post", "yourURL", 1
h.send

Why write script to call an ASP page that only does work but doesn't display ? If you are writing script, do the work inside the script.

*EXCUUUUSE ME* for trying to discourage a bad solution.

Damian

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-08-29 : 02:43:29

quote:
Why write script to call an ASP page that only does work but doesn't display ?

Oh, Damian... I don't know the exact answer. Maybe that 'strange'
ASP page is something like an ancillary page and is called from a 'regular'
ASP page by Execute method.
And now Steve would like to call (to execute) it from an Active Script Task
of a DTS package.
Of course, basically I understand pretty well what you mean and agree with you.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources