Hey all.. I've written a stored proc to execute a particular DTS package,
and that all works. What I'm trying to do now is trigger that process from
an ASP page... the following code *should* work I think.. and if so, then
what else might be keeping me from success???? HELP!
(The driver login criteria has been changed to protect the innocent)

<%
dim dataConn, sSql, rs
set dataConn = Server.CreateObject("ADODB.Connection")
dataConn.Open "Driver={SQL
Server};Server=hostservername;Database=DB;Uid=test ;Pwd=test;"
sSql = "{call SendDirectory}"
Set rs = dataConn.Execute(sSql) 'execute sql call
%>

Hi Adrian,

If you are not passing any parameters to the stored procedure, you could
just use:

sSQL = "sp_stored_procedure_name"

Hope this helps
Mark

"_adrian" <test @ test.com> wrote

Ah yes.. we actually had that in place first... and the behavior is
identical... the page says everything ran fine, but nothing actually
happens. If the stored proc is manually triggered, then DTS does its thing
fine too. Everything appears to be fine.. but there's a disconnect happening
somewhere!