Declare @execution_id bigint
Declare @environment_id bigint = 1 -- 1 = Dev, 2 = Prod
EXEC [SSISDB].[catalog].[create_execution] @package_name=N'Package.dtsx', @execution_id=@execution_id OUTPUT, @folder_name=N'Satisfaction Survey Load', @project_name=N'BizSol SatSurvey',
@use32bitruntime=False, @reference_id=@environment_id, @runinscaleout=False
Select @execution_id
DECLARE @var1 smallint = 3 --level 3 = 'Verbose' good for starting, level 1 = default (minimal?)
EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=50, @parameter_name=N'LOGGING_…