19. Review the SSIS package control flow shown in Figure 8.9. What is the
simplest way to receive an e-mail message after the “Import the Data” task
has run, but regardless of its status?
Figure 8.9 SSIS Package Control Flow
A. Change the “Send Email” tasks precedence constraint to be on completion
rather than success.
B. Remove the precedence constraint from the “Send Email” task.
C. Add a second precedence constraint between the “Import the Data” and
“Send Email” tasks and set the status to Failure.
D. Make a copy of the “Send Email” task and add a failure precedence
constraint to it from the “Import the Data” task.
Bạn đang xem 19. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P83 POT