get the app get the app       get the app       get the app
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.


  • : 196
  • : 9
    Previous Next

    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.

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

  • 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