How can I abort a package. I can't use a transaction as one of my activex
scripts uses a shell command so success or failure will not show up in the
workflow. I need to test for a condition in activex task and abort the
entire package accordingly. Regards, Chris.

By abort I will take it you mean "Exit gracefully". You can do this using
the object model quite easily.

Have a look at a few example here

Workflow
(http://www.sqldts.com/default.aspx?103)

--
--

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


"Chris Kennedy" <chrisknospam (AT) cybase (DOT) co.uk> wrote