T-SQL | Запустить SSIS Package из хранимой процедуры

Declare @execution_id bigint 

EXEC [SSISDB].[catalog].[create_execution] @package_name=N'Package.dtsx', @execution_id=@execution_id OUTPUT, @folder_name=N'SSIS Packages', @project_name=N'SSISPackage_ProjectDeployment', @use32bitruntime=False, @reference_id=1 

Select @execution_id 

DECLARE @var0 smallint = 3 

EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=50, @parameter_name=N'LOGGING_LEVEL', @parameter_value=@var0 

DECLARE @var1 int = 1 

EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=30, @parameter_name=N'Parameter1', @parameter_value=@var1 

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

См. http://technet.microsoft.com/en-us/library/jj820152.aspx