O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

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

Transactions: Doing multiple operations atomic

Doing multiple operations atomic is one of the fundamentals of each application which works with data. Many applications have transaction support; transactions are operations that will be run as one unique atomic operation. An atomic operation means that all operations will be run successfully or if an error happens and one of them caused the error all of them will rollback.

SSIS supports transactions also, but SSIS transaction differs from database transaction. SSIS can do most of the tasks atomically, you can copy files from source place to destination, extract them, transfer them to database, and if any error occurs you can rollback all operations.

SSIS uses the Microsoft Distributed Transaction ...

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