Microsoft Exam 70-463 Topic 3 Question 3 Discussion

To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is put in place.

The methodology has the following requirements:

* The deployment process must be simplified.

* All the logs must be centralized in SQL Server.

* Log data must be available via reports or T-SQL.

* Log archival must be automated.

You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort.

What should you do?