Edit

catalog.set_customized_logging_level_value

  • Article

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

Changes the statistics or the events logged by an existing customized logging level. For more info about customized logging levels, see Integration Services (SSIS) Logging.

Syntax

catalog.set_customized_logging_level_value [ @level_name = ] level_name  
    , [ @property_name = ] property_name  
    , [ @property_value = ] property_value

Arguments

[ @level_name = ] level_name
The name of an existing customized logging level.

The level_name is nvarchar(128).

[ @property_name = ] property_name
The name of the property to change. Valid values are PROFILE and EVENTS.

The property_name is nvarchar(128).

[ @property_value = ] property_value
The new value for the specified property of the specified customized logging level.

For a list of valid values for profile and events, see catalog.create_customized_logging_level.

The property_value is a bigint.

Remarks

Return Codes

0 (success)

When the stored procedure fails, it throws an error.

Result Set

None

Permissions

This stored procedure requires one of the following permissions:

  • Membership in the ssis_admin database role

  • Membership in the sysadmin server role

Errors and Warnings

The following list describes conditions that cause the stored procedure to fail.

  • The user does not have the required permissions.