I am creating a DTS package to execute a second DTS package conditionaly if a
row exists in table. How can I get an output parameter out of an "execute
SQL Task" and do conditional workflow based on the value?

You could use the Execute SQL Task and it's output parameyter support to get
the value out and into a variable. You could then use a Workflow script on
the following Execute Package Task to check the variable and return the
correct constant.

This has a simple example of workflow script if you need some more info-
How can I check if a file exists?
(http://www.sqldts.com/default.aspx?211)

--
Darren
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com

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