【单选题】You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the d...
A.
Select the DTS packages log package execution to SQL server check box. Create a SQL server alert to notify you if the package fails.
B.
Select the DTS packages write completion status to log check box. Create a SQL server alert to notify you if the package fails.
C.
Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails.
D.
Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.