ExecuteSsisPackageActivity interface

Execute SSIS package activity.

Extends

Properties

connectVia

The integration runtime reference.

environmentPath

The environment path to execute the SSIS package. Type: string (or Expression with resultType string).

executionCredential

The package execution credential.

loggingLevel

The logging level of SSIS package execution. Type: string (or Expression with resultType string).

logLocation

SSIS package execution log location.

packageConnectionManagers

The package level connection managers to execute the SSIS package.

packageLocation

SSIS package location.

packageParameters

The package level parameters to execute the SSIS package.

projectConnectionManagers

The project level connection managers to execute the SSIS package.

projectParameters

The project level parameters to execute the SSIS package.

propertyOverrides

The property overrides to execute the SSIS package.

runtime

Specifies the runtime to execute SSIS package. The value should be "x86" or "x64". Type: string (or Expression with resultType string).

type

Type of activity.

Inherited Properties

additionalProperties

Additional properties

dependsOn

Activity depends on condition.

description

Activity description.

linkedServiceName

Linked service reference.

name

Activity name.

onInactiveMarkAs

Status result of the activity when the state is set to Inactive. This is an optional property and if not provided when the activity is inactive, the status will be Succeeded by default.

policy

Activity policy.

state

Activity state. This is an optional property and if not provided, the state will be Active by default.

userProperties

Activity user properties.

Property Details

connectVia

The integration runtime reference.

connectVia: IntegrationRuntimeReference

Property Value

environmentPath

The environment path to execute the SSIS package. Type: string (or Expression with resultType string).

environmentPath?: any

Property Value

any

executionCredential

The package execution credential.

executionCredential?: SsisExecutionCredential

Property Value

loggingLevel

The logging level of SSIS package execution. Type: string (or Expression with resultType string).

loggingLevel?: any

Property Value

any

logLocation

SSIS package execution log location.

logLocation?: SsisLogLocation

Property Value

packageConnectionManagers

The package level connection managers to execute the SSIS package.

packageConnectionManagers?: Record<string, Record<string, SsisExecutionParameter>>

Property Value

Record<string, Record<string, SsisExecutionParameter>>

packageLocation

SSIS package location.

packageLocation: SsisPackageLocation

Property Value

packageParameters

The package level parameters to execute the SSIS package.

packageParameters?: Record<string, SsisExecutionParameter>

Property Value

Record<string, SsisExecutionParameter>

projectConnectionManagers

The project level connection managers to execute the SSIS package.

projectConnectionManagers?: Record<string, Record<string, SsisExecutionParameter>>

Property Value

Record<string, Record<string, SsisExecutionParameter>>

projectParameters

The project level parameters to execute the SSIS package.

projectParameters?: Record<string, SsisExecutionParameter>

Property Value

Record<string, SsisExecutionParameter>

propertyOverrides

The property overrides to execute the SSIS package.

propertyOverrides?: Record<string, SsisPropertyOverride>

Property Value

Record<string, SsisPropertyOverride>

runtime

Specifies the runtime to execute SSIS package. The value should be "x86" or "x64". Type: string (or Expression with resultType string).

runtime?: any

Property Value

any

type

Type of activity.

type: "ExecuteSSISPackage"

Property Value

"ExecuteSSISPackage"

Inherited Property Details

additionalProperties

Additional properties

additionalProperties?: Record<string, any>

Property Value

Record<string, any>

Inherited From ExecutionActivity.additionalProperties

dependsOn

Activity depends on condition.

dependsOn?: ActivityDependency[]

Property Value

Inherited From ExecutionActivity.dependsOn

description

Activity description.

description?: string

Property Value

string

Inherited From ExecutionActivity.description

linkedServiceName

Linked service reference.

linkedServiceName?: LinkedServiceReference

Property Value

Inherited From ExecutionActivity.linkedServiceName

name

Activity name.

name: string

Property Value

string

Inherited From ExecutionActivity.name

onInactiveMarkAs

Status result of the activity when the state is set to Inactive. This is an optional property and if not provided when the activity is inactive, the status will be Succeeded by default.

onInactiveMarkAs?: string

Property Value

string

Inherited From ExecutionActivity.onInactiveMarkAs

policy

Activity policy.

policy?: ActivityPolicy

Property Value

Inherited From ExecutionActivity.policy

state

Activity state. This is an optional property and if not provided, the state will be Active by default.

state?: string

Property Value

string

Inherited From ExecutionActivity.state

userProperties

Activity user properties.

userProperties?: UserProperty[]

Property Value

Inherited From ExecutionActivity.userProperties