Logging for Load Balanced Packages on Remote Servers
Applies To: SQL Server 2016
It is easier for an administrator to manage the logs for all the child packages that are running on various servers when all the child packages use the same log provider and they all write to the same destination. One way that you can create a common log file for all child packages is to configure the child packages to log their events to a SQL Server log provider. You can configure all the packages to use the same database, the same server, and the same instance of the server.
To view the log files, the administrator only has to log on to a single server to view the log files for all child packages.
For information about how to enable logging in a package, see Enable Package Logging in SQL Server Data Tools.