«

»

Dec
13

Setting a Default Logging Level in the SSIS Catalog

Categories:

by

2011/12/13

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.

Related posts:

  1. What Events are Included in the SSIS Catalog Log Levels

Tags: , , ,

Permanent link to this article: http://www.mattmasson.com/index.php/2011/12/setting-a-default-logging-level-in-the-ssis-catalog/

1 ping

  1. SSIS ETL Frameworks « Garrett Edmondson says:

    2012/01/03 at 8:42 pm (UTC -4 )

    [...] Server 2012 is going to ship with it’s own built in ETL Framework called SSIS Catalog. If you can upgrade I highly recommend doing [...]

Leave a Reply