Skip to content

Matt Masson

SQL Server Integration Services (SSIS), Power Query (PQ), Azure Data Factory (ADF), and general Data Integration

Setting a Default Logging Level in the SSIS Catalog

  • Home
  • 2011
  • December
  • Setting a Default Logging Level in the SSIS Catalog
Server, SQL Server MattDecember 13, 2011

One of the powerful features of the SSIS Catalog is that it can automatically capture logs for packages run on the server. The logging level is set to Basic by default, and can be changed when the package is run on the Advanced tab of the run UI (as shown below. This can also be done when scheduling the package through SQL Agent).

Logging level on Execute Package UI

You can set a server wide default logging level on the Catalog properties page.

  • Connect to the SQL Server instance using SSMS
  • Expand the Integration Services Catalogs node
  • Right click on the SSISDB node, select Properties
  • Change the Server-wide Default Logging Level setting (in the Operations Log category)

Catalog Properties

See What Events are Included in the SSIS Catalog Log Levels for more information.

DenaliLoggingServerSQL Server

Post navigation

What Events are Included in the SSIS Catalog Log Levels
Design Pattern: Avoiding Transactions

2 thoughts on “Setting a Default Logging Level in the SSIS Catalog”

  1. Pingback: SQL Server 2012 (“Denali”): SSIS Logging | James Serra's Blog
  2. Pingback: Jumping from SSIS 2008 to SSIS 2012 | James Serra's Blog

Comments are closed.

Copyright © 2021 | All Rights Reserved. CorpoNotch by Shark Themes