Bringing the Transaction mode with SSIS into reality.

Isn’t it a desirable request to run your Data flow Tasks into Transaction Mode that rolls back if something wrong happened in the middle. Will the functionality is there but you’ll need some configuration to bring it into life. Let’s have a look together. First you want to change the TransactionMode in the DataFlowTask properties…

1