Which three actions should you perform in sequence?

DRAG DROP
A SQL Server Integration Services (SSIS) package named DataFeed interacts with an
external vendor data feed. The package is executed several times a day, either as part of
other packages’ control flow or by itself. The external data feed is unreliable because
network failures and slow response times are frequent. The package is currently deployed
on the file system.
To analyze the reliability of the external data feed, you must collect execution data.
Every time the DataFeed package is executed, the following information must be logged:
Start Time
End Time
Execution Result
Execution Duration
You need to design a logging solution that meets the requirements by using the least
amount of administrative and development effort.
Which three actions 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
A SQL Server Integration Services (SSIS) package named DataFeed interacts with an
external vendor data feed. The package is executed several times a day, either as part of
other packages’ control flow or by itself. The external data feed is unreliable because
network failures and slow response times are frequent. The package is currently deployed
on the file system.
To analyze the reliability of the external data feed, you must collect execution data.
Every time the DataFeed package is executed, the following information must be logged:
Start Time
End Time
Execution Result
Execution Duration
You need to design a logging solution that meets the requirements by using the least
amount of administrative and development effort.
Which three actions 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 4

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


dbo

dbo

1. Create a new project
2. Deploy new project w/ package to the SSIS catalog
3. Query catalog.executable_statistics view

name

name

why to the SSIS catalog, It does not say that it is SQL 2012?

Min

Min

we cant view atalog.executable_statistics without deploying to SSIS catalog.
SQL2008 no catalog.