get the app get the app       get the app       get the app
You are an ETL developer. You maintain a SQL Server 2008 Integration Services (SSIS) instance.

You need to develop a parent package that meets the following requirements:
The parent package can execute child packages by using multiple execute Package tasks.
A notification needs to be sent before executing the parent package and after executing all child packages.
If any packages have errors during execution, the subsequent package should run after the failure.
Only one error notification email should be sent that lists all package errors from the parent package.

What should you do? (Each correct answer presents part of the solution. Choose three.)

1)Set the precedence constraints between child packages to success.
2)Set the precedence constraints between child packages Completion.
3)Add a Send Mail Task to the child packages' OnPostExecution event handler.
4)Add a Send Mail Task to the child packages' OnPostExecution event handler.
5)Send Mail Task to the parent packages' OnError event handler.

  • : 219
  • : 8
    Previous Next

    Set the precedence constraints between child packages Completion.

    Add a Send Mail Task to the child packages' OnPostExecution event handler.

    Send Mail Task to the parent packages' OnError event handler.

    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