I have 3 tasks in a SSIS package. If the final task fails I only want that task to rollback.
Do I just set that task to REQUIRED? Or leave it as SUPPORTED?
SSIS Transaction Level
The default transaction level for all tasks and containers is
You have 3 Tasks and the desire is to have the third item behave in an atomic way. The answer is, partially, that you'll want to set the Transaction option to