Hi,
I have two questions that I have no idea how it works.
1. I created a stored procedure that returns a value after execution
e.g.
Create Procedure try @output nvarchar(50) output as .... return
how am i able to get the output value from the stored procedure using DTS, I
do it in Execute SQL Task or ???
2. How am i able to fire a stored procedure using Active X Script

Thanks
Ed

If you are talking about capturing the value of an OUTPUT parameter, then it
is the same as you normally would - you'll have to do that in an Execute SQL
task.

To be able to run a stored proc from an ActiveX script, you'll have to
instantiate an ADO connection object, just like you would in a normal
VBScript application.

Is this enough to get you started? If not, post back, and someone will post
an example for you.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


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

First of all, thanks for your answer...
The main problem i have is in Execute SQL Task, i put something like
Declare @output nvarchar(10)
Exec ProcedureName @output output

it failed, and i don't know how to put that output parameter into a Global
Variable,
that's why I asked if it should be done in Active X Script...
If it has to be done in Active X Script, the code is like
dim cmd as new adodb.command
set cmd.activeconnection = xxx
cmd.commandtext = xxx
....
....
right?

Thanks again.
Ed

"Ed" wrote:

This is covered on SQLDTS.com. See: http://www.sqldts.com/default.aspx?234

--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


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