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: See the explanation
Ref: http://msdn.microsoft.com/en-us/library/hh479592.aspx