DTS xChange has a series of enterprise-ready rules to help you migrate your DTS packages to SSIS quickly and easily. After you select the packages that you wish to migrate, you then specify the rules on the Specify Rules screen in the wizard.   

By enabling this rule, all converted packages will be wrapped in a MSDTC transaction. Wrapping a package in a transaction ensures that data events are protected by a transaction. If a data problem occurs all actions that have occurred in the data are rolled back. Enabling this feature will require that the Microsoft Distributed Transaction Coordinator (MSDTC) service is enabled on each server participating in the package.

Transaction Options

By enabling this rule, you can then specify what type of transactions you wish to use. The default option is Serializable, which is one of the most protective option. Other options are:

• ReadUncommitted - Allows reading of uncommitted data by another process in the same transaction.
• ReadCommitted - A protective setting which allows the process to only view another processes' data once it's committed.
• Snapshot - A SQL Server 2005 feature that allows you to take a snapshot of the data and changes are tracked in the tempdb.
• Serializable - The default option and the most restrictive. An update lock is placed on the data and is not released until the transaction commits.
• Chaos - The least resetrictive of the settings. Similar to the ReadUncommitted setting but does not hold an update lock on the data.
• RepeatableRead - Locks data being read by the transaction until the transaction is committed.