FROM MSDN:-
Other Interview Questions
What is Transaction in SSIS package and how to implement
it? (SSIS Interview Questions)
Packages use transactions to bind the database actions
that tasks perform into atomic units, and by doing this maintain data
integrity. All Microsoft Integration Services container types—packages,
the For Loop, For each Loop, and Sequence containers, and the task hosts that
encapsulate each task—can be configured to use transactions. Integration
Services provides three options for configuring transactions: NotSupported,
Supported, and Required.
- Required indicates that the container starts a transaction,
unless one is already started by its parent container. If a transaction
already exists, the container joins the transaction. For example, if a
package that is not configured to support transactions includes a Sequence
container that uses the Required option, the Sequence container
would start its own transaction. If the package were configured to use the
Required option, the Sequence container would join the package
transaction.
- Supported indicates that the container does not start a
transaction, but joins any transaction started by its parent container. For
example, if a package with four Execute SQL tasks starts a transaction and
all four tasks use the Supported option, the database updates
performed by the Execute SQL tasks are rolled back if any task fails. If
the package does not start a transaction, the four Execute SQL tasks are
not bound by a transaction, and no database updates except the ones
performed by the failed task are rolled back.
- NotSupported 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. For example, if a package is
configured to start a transaction and a For Loop container in the package
uses the NotSupported option, none of the tasks in the For Loop can
roll back if they fail.
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?
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?
No comments:
Post a Comment