Implementing Transactions in SSIS

Let’s say you’ve many control tasks and you’ve to implement transaction.
Points to Note:
1. You cannot Implement Transaction in a task which has truncation
2. Transaction has no effects in file processing and archiving it works only for DB

If you want to have transaction for only one task then select the Isolation Level as “Serializable” and TransactionOption as “Required”

If you want to have transactions for many or all of the control tasks then set the TransactionOption as “Required” in the package and “Supported” in the Control Tasks.
For the Control Task s where you doesn’t require transaction choose “Not Supported”