DRAG DROP
You are designing a SQL Server Integration Services(SSIS) package. The package moves order-related data
to a staging table named Order. Every night the staging data is truncated and then all the recent orders from
the online store database are inserted into the staging table. Your package must meet the following
requirements:
If the truncate operation fails, the package execution must stop and report an error.
If the Data Flow task that moves the data to the staging table fails, the entire refresh operation must be
rolled back.
For auditing purposes, a log entry must be entered in a SQL log table after each execution of the DataFlow
task.
The TransactionOption property for the package is set to Required. You need to design the package to meet
the requirements. How should you design the controlflow for the package? (To answer, drag the appropriate
setting from the list of settings to the correct location or locations in the answer area.)
Answer:
Explanation:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms137690.aspx
http://msdn.microsoft.com/en-us/library/ms141144.aspx
