Selectively executing steps disablestep -- sql server dts

fcagg
4/14/2004 7:09:39 AM

I have a package with many steps.
Depending on the circumstances, I only want certain steps
to execute.
The steps run serially, and are connected with an "On
Completion" workflow.
Each step's DisableStep property is valued using an INI
that is set by a Dynamic Property Task that runs first.
The idea is if I only want to execute the odd numbered
steps, I would set the DisableStep property of the even
numbered steps to 1(TRUE).
The problem is that dts does not consider a disabled step
Completed (or Failed for that matter).
Is there a way to selectively execute certain steps,
without modifying the package?

Darren Green
4/18/2004 11:28:48 AM

In message <2b3f01c4222a$1fc6a760$3a01280a@phx.gbl>, fcagg
<Fcaggiano@us.imshealth.com> writes
[quoted text, click to view]

Since disabled step does not match an On Completed constraint, what you
need to do is change the constraint to a On Not Run. Constraints can
either use the step result or step status. All these properties and
constants are documented in Books Online, but here is a sample-

Skip the execution of an individual Task
(http://www.sqldts.com/default.aspx?214)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

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

sql server dts : Selectively executing steps disablestep