Is there a way to make a particular task in DTS conditional based on a
global parameter value?
Something like
IF globalparam1 = 1 Then
execute task1

I don't mean the work flow where a task will be executed on completion of
some other task.

Then you want this

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

--


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




"Anant Rege" <arege.at.rogers.dotcom> wrote