|
Home > Archive > MS SQL Server DTS > June 2005 > Stored Procedure from DTS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Stored Procedure from DTS
|
|
| Chris Kennedy 2005-06-28, 9:23 am |
| Can anyone tell me how, I can execute a stored procedure in a DTS and
depending on the output parameter execute the rest of the stored procedure
or else write to a log file?
| |
|
| Chris
You can use "Execute SQL Task" to call a stored procedure. Can you explain
more about what exactly you are trying to do?
--
Thanks
Ravi
"Chris Kennedy" wrote:
> Can anyone tell me how, I can execute a stored procedure in a DTS and
> depending on the output parameter execute the rest of the stored procedure
> or else write to a log file?
>
>
>
| |
| Allan Mitchell 2005-06-28, 1:23 pm |
| Do you mean that based on what is returned in the OUTPUT parameter in a proc
you either carry on with the package or exit gracefully after logging the
fact?
If you do then yes this is possible
Have a look at these articles.
Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/default.aspx?234)
Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Chris Kennedy" <chrisknospam@cybase.co.uk> wrote in message
news:uGkhZs%23eFHA.3504@TK2MSFTNGP14.phx.gbl...
> Can anyone tell me how, I can execute a stored procedure in a DTS and
> depending on the output parameter execute the rest of the stored procedure
> or else write to a log file?
>
|
|
|
|
|