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

Catalog Name: Implied by the database name in
Integration Server 2014
|-Folder Name: A folder created before or at Deployment
to contain the SSIS project
|-Project Name: The name of the SSIS Project deployed
|-Package Name: The name(s) of the SSIS Package(s)
deployed
Parameters:
@FolderName [nvarchar(128)] {No default} - contains
the name of the
Folder that holds the SSIS Project
@ProjectName [nvarchar(128)] {No default} - contains
the name of the
SSIS Project that holds the SSIS Package
@PackageName [nvarchar(260)] {No default} - contains
the name of the
SSIS Package to be executed
@ExecutionID [bigint] {Output} - Output parameter
(variable) passed back
to the caller
@LoggingLevel [varchar(16)] {Default} - contains the
(case-insensitive)
name of the logging level to apply to this execution
instance
@Use32BitRunTime [bit] {Default} - 1 == Use 64-bit
run-time
0 == Use 32-bit
run-time
@ReferenceID [bigint] {Default} - contains a reference
to an Execution Environment
@ObjectType [smallint] - contains an identifier that
appears to be related
to the SSIS PackageType property
Guessing: @ObjectType == PackageType.ordinal
(1-based-array) * 10
Must be 20, 30, or 50 for
catalog.set_execution_parameter_value