Hi:

I have several data pumps in a package and, if one fails, I want all of
them to fail, kind of like rolling back a transaction. So bascially no
data gets written to any of the destinations unless all of it can.

How to do this?

Thanks,
Kayda

Then use a transaction.

I mention this here

http://groups-beta.google.com/group/...04ff5f36c75773

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"kayda" <tabladude (AT) gmail (DOT) com> wrote