sql server dts: 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?

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


[quoted text, click to view]

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


[quoted text, click to view]