SSIS interview Questions : SSIS Transaction Options

In SSIS there are three options which SSIS package has for transaction

Required 

if container transaction property is set to required then container start (if not already started by parent container or package) or joins existing transaction( which is started by parent)

Supported

 if container transaction property is set to supported then container can be the part of all ready running transactions but won’t start it new one in any case. Let say if for a execute sql task if transaction property is set to supported then if there is any other transaction already there then it will join it and will roll back in case of any failure in any part of that parent transaction while if there is no parent transactions it will implement the changes in database even if any other task shows error in same package.

Not Supported

 indicates that the container does not start a transaction or join an existing transaction. A transaction started by a parent container does not affect child containers that have been configured to not support transactions.

KeyWord: Transaction options in SSIS package , SSIS Transaction , How to implement transaction in SSIS.

Other Interview Questions

Question: Can we implement transactions in SSIS package?
Question: What are different transaction Options in SSIS?
Question Which control flow tasks doesn't support transactions?
Question: How to implement isolation level in SSIS package?
Question: What is chaos in isolation level options in SSIS?

SSIS Interview Questions