Transactions in SSIS

Transactions in SSIS 9

Similar to the SQL Server, SQL Server Integration Services or SSIS also includes the Transaction Options to maintain the Data Integrity. There are three types of Transaction options in SSIS, and you can use them in containers, tasks, etc.  The following are the list of available Transactions in SSIS Not Supported: It does not start a new transaction, … Read more