get the app get the app       get the app       get the app


Question: 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?
1)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.
2)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.
3)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.
4)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.


Previous Next
Exam


Suggest other answer
Login to Discuss/suggest the answer...

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence





Recommended Learning for you

Close(X)
Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material