Question: You created an SSIS task to audit certain event and if the event fails, a log should be recorded. How should you configure the transaction
You created an SSIS task to audit certain event and if the event fails, a log should be recorded. How should you configure the transaction properties for this task? Group of answer choices Set the TransactionOption property to Required Set the TransactionOption property to Supported Set the TransactionOption property to NotSupported Set the TransactionOption property to Fail
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
