You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. The SSIS package must contain six Data Flow tasks and three Control Flow tasks. What should you do?

• A. You should consider creating two Control Flow tasks and one Data Flow task on a container. Then the TransactionOption property of the container should be set to Supported.
• B. You should consider creating two Control Flow tasks and one Data Flow task on a container. Then the TransactionOption property of the container should be set to NotSupported.
• C. You should consider creating two Control Flow tasks and one Data Flow task on a container. Then the TransactionOption property of the container should be set to Required.
• D. You should consider creating two Control Flow tasks and one Data Flow task on a container. Then the TransactionOption property of the container should be set to RequiredNew.