Transaction
It is built in to SSIS. TransactionOption can be divided in to three ways:
1.Required
2.Supported
3.NotSupported
Enable TransactionOption
On the task level property turn ‘FailPackageOnFailure’ to ‘False’ and Change the ‘FailParentOnFailure’ to ‘True’. Then in the sequence container properties change ‘FailPackageOnFailure’ to ‘True’.
Then Set the sequence container to transacted by:
It is built in to SSIS. TransactionOption can be divided in to three ways:
1.Required
2.Supported
3.NotSupported
Enable TransactionOption
On the task level property turn ‘FailPackageOnFailure’ to ‘False’ and Change the ‘FailParentOnFailure’ to ‘True’. Then in the sequence container properties change ‘FailPackageOnFailure’ to ‘True’.
Then Set the sequence container to transacted by:
1.Change container property ‘transaction option’ to required
2.Change contained tasks’ ‘transaction option’ to supported
