I create one SP to execute SSIS Catalog using T-SQL.

It sometimes helps to execute SSIS package dynamically.

Full script download link.

exec [dbo].[USP_EXEC_SSIS_Catalog] @folder_name NVARCHAR(128) , @project_name NVARCHAR(128) , @package_name NVARCHAR(260) , @Multi_CustomValue VARCHAR(MAX)= NULL –“|#||##||#|… Ex. “SyncBack_Period_DD|#|-14|##|BackupFolder|#|X:\Test” , @reference_id BIGINT = NULL , @use32bitruntime BIT = 0 , @execution_id BIGINT = NULL OUTPUT