DRAG DROP
You are editing a SQL Server Integration Services (SSIS) package that uses checkpoints.
The package performs the following steps:
1. Download a sales transaction file by using FTP.
2. Truncate a staging table.
3. Load the contents of the file to the staging table.
4. Merge the data with another data source for loading to a data warehouse.
The checkpoints are currently working such that if any of the four steps fail, the package will
restart from the failed step the next time it executes.
You need to modify the package to ensure that if either the Truncate Staging Table or the
Load Sales to Staging task fails, the package will always restart from the Truncate Staging
Table task the next time the package runs.
Which three steps should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Answer: 
Open SSIS Toolbox
Move the Truncate Staging Table and Load …
Set the FailPackageOnFailure property of the container to True
0
0
Why ‘Open SSIS Toolbox?!’ What for?!
Correct options are:
1. Move ‘Truncate Staging Table’ and ‘Load Sales to Staging Table’ into a new Sequence container…
2. Set the ‘FailPackageOnFailure’ property of the Sequence container to TRUE
3. Set the ‘ForceExecutionResult’ property of the Truncate Staging Table task to Success.
0
0
Pls ignore the 3rd option in my previous post. Cao is right; you have to open SSIS Toolbox in order to add the Sequence container!!
1
0
I think that 8 – 7 – 5. 5 contains both – move into container and set ‘FailPackageOnFailure’to true
0
0
https://sqlserverrider.wordpress.com/tag/failpackageonfailure/
In the link stated above we have the following 2 key sentences that answer directly the question :
1. The completion of any child containers of transacted container is not recorded in the checkpoint file. So, the child containers will be executed again while we rerun the package and that will start from the point of failure (that is transaction container).
2. Mandatory step before we create checkpoints.
FailPackageOnFailure property must be true in all containers to set the checkpoint/restart point.
So from 1. and 2. we can say that Cao’s answer is correct.
For reminder Cao’s answer was :
==> Open the SSIS ToolBox
==> Move the Truncate Staging Table and Load …
==> Set the FailPackageOnFailure property of the container to True
0
0