Diving deep into SQL Server Integration Services Transactions Author: Basit A. Farooq In this article, you learn how to implement transactions in a SQL Server Integration Services package. What are transactions? A transaction is a logical unit of work made up of one or more tasks. The concept of transaction usually applies to a relational database such as those in...