custom_log_level.sql

-- Set up the execution instance
DECLARE @execution_id BIGINT
EXEC [SSISDB].[catalog].[create_execution] 
	@package_name = N'30 Parameterized Package.dtsx'
	, @execution_id = @execution_id OUTPUT
	, @folder_name = N'Making the Most of the SSIS Catalog'
	, @project_name = N'Making the Most of the Catalog'
	, @use32bitruntime = False
	, @reference_id = 2

/*
	Set logging level 100 to indicate a custom log level
*/
DECLARE @logLevel SMALLINT = 100
EXEC [SSISDB].[catalog].[set_execution_parameter_value] 
	@execution_id
	, @object_type = 50
	, @parameter_name = N'LOGGING_LEVEL'
	, @parameter_value = @logLevel

/*
	Set CUSTOMIZED_LOGGING_LEVEL to the name of the
	custom log level for this execution
*/
DECLARE @logLevelName SQL_VARIANT = N'New Custom Logging Level'
EXEC [SSISDB].[catalog].[set_execution_parameter_value] 
	@execution_id
	, @object_type = 50
	, @parameter_name = N'CUSTOMIZED_LOGGING_LEVEL'
	, @parameter_value = @logLevelName

-- Execute the package
EXEC [SSISDB].[catalog].[start_execution] @execution_id
GO