Enable Package Logging in SQL Server Data Tools
Applies To: SQL Server 2016
This procedure describes how to add logs to a package, configure package-level logging, and save the logging configuration to an XML file. You can add logs only at the package level, but the package does not have to perform logging to enable logging in the containers that the package includes.
By default, the containers in the package use the same logging configuration as their parent container. For information about setting logging options for individual containers, see Configure Logging by Using a Saved Configuration File.
In SQL Server Data Tools, open the Integration Services project that contains the package you want.
On the SSIS menu, click Logging.
Select a log provider in the Provider type list, and then click Add.
In the Configuration column, select a connection manager or click <New connection> to create a new connection manager of the appropriate type for the log provider. Depending on the selected provider, use one of the following connection managers:
For Text files, use a File connection manager. For more information, see File Connection Manager
For SQL Server Profiler, use a File connection manager.
For SQL Server, use an OLE DB connection manager. For more information, see OLE DB Connection Manager.
For Windows Event Log, do nothing. SSIS automatically creates the log.
For XML files, use a File connection manager.
Repeat steps 3 and 4 for each log to use in the package.
A package can use more than one log of each type.
Optionally, select the package-level check box, select the logs to use for package-level logging, and then click the Details tab.
On the Details tab, select Events to log all log entries, or clear Events to select individual events.
Optionally, click Advanced to specify which information to log.
By default, all information is logged.
On the Details tab, click Save. The Save As dialog box appears. Locate the folder in which to save the logging configuration, type a file name for the new log configuration, and then click Save.
To save the updated package, click Save Selected Items on the File menu.