O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

DTS and Transactions

Normally, each modification within a DTS package is committed as it's made. The Use transactions package property controls whether the package initiates a transaction when executed. And although this property defaults to true, you must also enable the Join transaction if present workflow property for a step in order to actually queue changes to a transaction. Since this workflow property is false by default, changes made within a package are normally committed as soon as they're made.

You can configure a package to log its changes in a transaction by:

  • Enabling the Use transactions package property (which is true by default) and

  • Enabling the Join transaction if present workflow property for each step that you want to participate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required