log_level.sql

-- Create 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 the logging level below using the 
	system parameter LOGGING_LEVEL. Setting
	this to 3 translates to Verbose logging.
*/
DECLARE @logLevel SMALLINT = 3	
EXEC [SSISDB].[catalog].[set_execution_parameter_value] 
	@execution_id
	, @object_type = 50
	, @parameter_name = N'LOGGING_LEVEL'
	, @parameter_value = @logLevel

-- Execute
EXEC [SSISDB].[catalog].[start_execution] @execution_id