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 Data Flow 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 control flow for the package? (To answer, drag the appropriate setting from
the list of settings to the correct location or locations in the answer area.)
Explanation:
http://msdn.microsoft.com/en-us/library/ms137690.aspx
http://msdn.microsoft.com/en-us/library/ms141144.aspx
1.TransactionOption:Supported (because of “The TransactionOption property for the package is set to Required.”)
2.Precedence Constraint: Success
3.TransactionOption:Supported
4.Precedence Constraint: Complete (For auditing purposes, a log entry must be entered in a SQL log table after each
execution of the Data Flow task)
5.TransactionOption: Not supported (For auditing purposes, a log entry must be entered in a SQL log table after each
execution of the Data Flow task)