Which three steps should you perform in sequence?

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.)

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:



Leave a Reply 9

Your email address will not be published. Required fields are marked *


DM

DM

1. open ssis tool box
2. move the truncate staging table ….
3. set the failpackageonfailure property of the cotainer..

Bharathi

Bharathi

which answer is correct? above given answer or DM’s answer

Kane

Kane

DM is correct

Islam

Islam

this comment looks correct

MKL

MKL

Agree with DM.

Razo

Razo

agree with DM

cao

cao

open ssis tool box
move the truncate staging table ….
set the failpackageonfailure property of the cotainer..