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: 
I don’t see why the SSIS toolbox should be opened? In my view, this should be replaced by ‘Move the Truncate Staging table and Load Sales to Staging tasks to a new sequence container. Otherwise there is no container present and the next 2 options are also false.
0
0
Open SSIS Toolbox
Move ‘Truncate Staging Table’ and ‘Load Sales to Staging Table’ into a new Sequence container…
Set the FailPackageOnFailure property of the container to True
0
0
Open the dataflow page.
Move ‘Truncate Staging Table’ and ‘Load Sales to Staging Table’ …
Set the FailPackageOnFailure property …
0
0
Sequence Container is not available in DataFlow page.
0
0
The toolbox thing is a bit of a trick really, it’s usually on the left hand side so we wouldn’t think of it as a ‘step’… But if you think about it that is where you get the sequence container from…
0
0
Agree with dbo
Open SSIS Toolbox
Move ‘Truncate Staging Table’ and ‘Load Sales to Staging Table’ into a new Sequence container…
Set the FailPackageOnFailure property of the container to True
0
0
Do you even need the third step of “Set the FailPackageOnFailure property of the container to True” if you have already set the FailParentonFailure property to True?
0
0
DBO is right.
0
0