Hi!
Is there any way to disable all the remaining steps on a package?
I have about 20 steps and I didn't want to disable one by one.
Thank you!
Eduardo

Eduardo,

You need to disable only root step(s). Subsequent steps would not be
executed.

Ilya

"Eduardo Greco" <eduardo (AT) persocom (DOT) com.br> wrote

Grab the Package object
Now the steps
Now set the Disable property

dim pkg, stp


SET pkg = DTSGlobalVariables.Parent

FOR EACH stp in pkg.Steps
If stp.Name <> "My Name" THEN
stp.DisableStep = True
End If
NEXT

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Eduardo Greco" <eduardo (AT) persocom (DOT) com.br> wrote

The only problem there would be if there was no workflow constraining the
steps

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Ilya Margolin" <ilya_no_spam_ (AT) unapen (DOT) com> wrote