Hi
I need to execute a sql task inside an Activex script which essentially executes a SP inside a loop. The task takes global variables as input parameters.

How to execute a task inside an Activex script

Thanks
Aji

You can create a database connection with ADO inside your ActiveX script and
use that to execute the stored procedure, or you can create a loop in DTS as
described in the following article:
http://www.sqldts.com/default.aspx?246

However, I think there are easier ways to achive what you want, can you
provide some more information about what you exactly want to do?

--
Jacco Schalkwijk
SQL Server MVP


"Ajit" <anonymous (AT) discussions (DOT) microsoft.com> wrote

parameters.