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.)
Select and Place:
catalog.executable_statistics is right. It has
Start_time datetimeoffset(7) The time when the executable enters the pre-execute phase.
End_time datetimeoffset(7) The time when the executable enters the post-execute phase.
Execution_duration int The length of time the executable spent in execution. The value is in milliseconds.
Execution_result smallint The following are the possible values:
but
catalog.execution_data_statistics
doesn’t have it