I am using a DTS package with quite a few steps to transfer data across the
internet from Access to SQL Server. If one of the steps fail, I want all the
previous steps to be rolled back.

Does this happen automatcially or can I set this up to happen ?

You need to set it up.

Remember that some things, like a text file, cannot take part in
transactions.

Anyway here is a search for my previous answers to questions just like this

http://groups.google.com/groups?q=%2...x.g bl&rnum=8

--
--

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


"Craig HB" <CraigHB (AT) discussions (DOT) microsoft.com> wrote