Execution Patterns - SQL Server Integration Services Design Patterns - page 53

Output
3. When execution completes, an Execution_Id value
should be returned.
View the SSIS Catalog Reports to determine the
status of the
execution instance and the test.
*/
Create Procedure
[custom].[execute_catalog_package_with_data_tap]
@FolderName nvarchar(128)
,@ProjectName nvarchar(128)
,@PackageName nvarchar(260)
,@DataFlowTaskName nvarchar(255)
,@IdentificationString nvarchar(255)
,@DataTapFileName nvarchar(4000)
,@ExecutionID bigint Output
,@LoggingLevel varchar(16) = 'Basic'
,@Use32BitRunTime bit = 0
,@ReferenceID bigint = NULL
,@ObjectType smallint = 50
,@DataTapMaxRows int = NULL
As
begin
Set NoCount ON
/* Call the catalog.create_execution stored procedure
to initialize execution location and parameters */
Exec catalog.create_execution
@package_name = @PackageName
,@execution_id = @ExecutionID Output
,@folder_name = @FolderName
,@project_name = @ProjectName
,@use32bitruntime = @Use32BitRunTime
,@reference_id = @ReferenceID