Transactions within DTS packages serve the same purpose as in other SQL Server based operations - they provide the set of features described collectively using the term ACID, which is an acronym derived from four transactional characteristics - atomicity, consistency, isolation and durability. See further...