Re: Calling a stored procedure from Activex Script

#1

Thanks for your help. This helped me alot but I still have
a small problem, this runs the stored procedure but I am
trying get some output parameter from the stored
procedure...But it is not giving the output. Any help?

thanks,

Quote:

-----Original Message-----
Then use Workflow to determine if that task should run or
not

Workflow
(http://www.sqldts.com/default.aspx?103)

Alternatively you could just use ADO inside the Active X
Script task.

This thread should help

http://tinyurl.com/2nx44

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

anonymous (AT) discussions (DOT) microsoft.com> wrote in message
news:1540301c415d2$53beb8a0$a501280a (AT) phx (DOT) gbl...
Need small help in how to call a stored procedure from
Activex Script. Using Execute sql task, it will be easy
but I don't want to execute that task all the time.
Only
in certain situations, I need to run the stored
procedure.
Any code examples?

thanks,

.

#2

In message <19d9301c41cd4$40207550$a101280a (AT) phx (DOT) gbl>,
anonymous (AT) discussions (DOT) microsoft.com writes

Quote:

Thanks for your help. This helped me alot but I still have
a small problem, this runs the stored procedure but I am
trying get some output parameter from the stored
procedure...But it is not giving the output. Any help?

thanks,

You will need to use the ADO Command object, and the Parameters
collection. You can specify parameters as Input, Output and InputOutput.

Lookup up the Command object and Parameters collection on MSDN.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Calling a stored procedure from Activex Script

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Calling a stored procedure from Activex Script - 04-07-2004 , 02:12 PM

Re: Calling a stored procedure from Activex Script - 04-13-2004 , 01:08 PM