Implementing Reliable ETL Processes with SQL Server Integration Services Author: Basit A. Farooq In our previous three-part article series “Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design”, we have focused on logging and error handling both vital considerations to ensure long-term reliability of your SQL Server Integration Services packages. However, there are other...
Tag: transactions
Diving deep into SQL Server Integration Services Transactions
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...