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


Question: 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.


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