execute_params.sql

USE SSISDB;
GO

DECLARE @execution_id BIGINT;
EXEC [SSISDB].[catalog].[create_execution]
	@package_name = N'DEMO SFTP List.dtsx'
	, @execution_id = @execution_id OUTPUT
	, @folder_name = N'SSIS Parameters'
	, @project_name = N'SSIS Parameters'
	, @use32bitruntime = False
	, @reference_id = NULL
	, @runinscaleout = False;

EXEC [catalog].[set_execution_parameter_value]
	@execution_id
	, @object_type = 20
	, @parameter_name = N'ppPassword'
	, @parameter_value = N'DontReadMyPassword';

EXEC [SSISDB].[catalog].[set_execution_parameter_value]
	@execution_id
	, @object_type = 20
	, @parameter_name = N'ppUserName'
	, @parameter_value = N'foo';

/*
	Other parameters here
*/

EXEC [SSISDB].[catalog].[start_execution] @execution_id;
GO