Several tasks in my SSIS package use stored procedures. Inside the SP Ive used a transaction that rolls back on failure. Because Ive used a transaction inside the SP, do I also have to set the TransactionOption of the task to 'Required' and the isolationLevel to 'ReadCommitted' ?
Im using checkpoints so ive also set FailPackageOnfailure to 'True' so i can restart after a rollback.