Configure Logging by Using a Saved Configuration File
This procedure describes how to configure logging for new containers in a package by loading a previously saved logging configuration file.
By default, all containers in a package use the same logging configuration as their parent container. For example, the tasks in a Foreach Loop use the same logging configuration as the Foreach Loop.
To configure logging for a container
In SQL Server Data Tools, open the Integration Services project that contains the package you want.
On the SSIS menu, click Logging.
Expand the package tree view and select the container to configure.
On the Providers and Logs tab, select the logs to use for the container.
Note
You can create logs only at the package level. For more information, see Enable Logging in a Package.
Click the Details tab and click Load.
Locate the logging configuration file you want to use and click Open.
Optionally, select a different log entry to log by selecting its check box in the Events column. Click Advanced to select the type of information to log for this entry.
Note
The new container may include additional log entries that are not available for the container originally used to create the logging configuration. These additional log entries must be selected manually if you want them to be logged.
To save the updated version of the logging configuration, click Save.
To save the updated package, click Save Selected Items on the File menu.