Here's the syntax created opening the package(s) into Integration Catalogue | Execute | explicitly provide new parameter, then use script function to generate code. It does work if exec step 1, wait 5 minutes exe step 2 - only problem step 2 should wait until step 1 has completed the file move otherwise the folder it inserts from is empty (until step 1 completes)
-- Step #1 (this package collects .csv's from one folder and relocates into another. takes 3 minutes)
Declare @execution_id bigint
EXEC [SSISDB].[catalog].[create_execution] @package_name=N'name.dtsx', @execution_id=@execution_id OUTPUT, @folder_name=N'folder', @project_name=N'project', @use32bitruntime=False, @reference_id=Null
Select @execution_id
DECLARE @var0 datetime = N'2015-09-24T11:25:57.000'
EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=30, @parameter_name=N'pFileDate', @parameter_value=@var0
DECLARE @var1 sql_variant = N'H:\some_Location'
EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=30, @parameter_name=N'pFilePath', @parameter_value=@var1
DECLARE @var2 sql_variant = N'H:\some_Location'
DECLARE @var sql_variant = N'H:\some_Location'
EXEC [SSISDB].[catalog].[set_object_parameter_value] @object_type=30, @parameter_name=N'pFilePath', @object_name=N'name.dtsx', @folder_name=N'folder', @project_name=N'project', @value_type=V, @parameter_value=@var
EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=30, @parameter_name=N'pSourceDir', @parameter_value=@var2
DECLARE @var3 sql_variant = N'Data Source=instance;Initial Catalog=source;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;'
EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=30, @parameter_name=N'CM.HDS.ConnectionString', @parameter_value=@var3
DECLARE @var4 smallint = 3
EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=50, @parameter_name=N'LOGGING_LEVEL', @parameter_value=@var4
EXEC [SSISDB].[catalog].[start_execution] @execution_id
GO
-- step #2 (this package then bulk inserts the .csv into sql tables)
Declare @execution_id bigint
EXEC [SSISDB].[catalog].[create_execution] @package_name=N'name.dtsx', @execution_id=@execution_id OUTPUT, @folder_name=N'folder', @project_name=N'project', @use32bitruntime=False, @reference_id=Null
Select @execution_id
DECLARE @var0 sql_variant = N'H:\some_Location'
EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=30, @parameter_name=N'pFilePath', @parameter_value=@var0
DECLARE @var1 sql_variant = N'Data Source=.;Initial Catalog=source;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;'
EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=30, @parameter_name=N'CM.HDS.ConnectionString', @parameter_value=@var1
DECLARE @var2 smallint = 2
EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=50, @parameter_name=N'LOGGING_LEVEL', @parameter_value=@var2
EXEC [SSISDB].[catalog].[start_execution] @execution_id
GO