Package version:

Interface SqlServerStoredProcedureActivity

SQL stored procedure activity type.

interface SqlServerStoredProcedureActivity {
    dependsOn?: ActivityDependency[];
    description?: string;
    linkedServiceName?: LinkedServiceReference;
    name: string;
    onInactiveMarkAs?: string;
    policy?: ActivityPolicy;
    state?: string;
    storedProcedureName: any;
    storedProcedureParameters?: any;
    type: "SqlServerStoredProcedure";
    userProperties?: UserProperty[];
}

Hierarchy (view full)

Properties

dependsOn? description? linkedServiceName? name onInactiveMarkAs? policy? state? storedProcedureName storedProcedureParameters? type userProperties?

Properties

OptionaldependsOn

dependsOn?: ActivityDependency[]

Activity depends on condition.

Optionaldescription

description?: string

Activity description.

OptionallinkedServiceName

linkedServiceName?: LinkedServiceReference

Linked service reference.

name

name: string

Activity name.

OptionalonInactiveMarkAs

onInactiveMarkAs?: string

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.

Optionalpolicy

policy?: ActivityPolicy

Activity policy.

Optionalstate

state?: string

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

storedProcedureName

storedProcedureName: any

Stored procedure name. Type: string (or Expression with resultType string).

OptionalstoredProcedureParameters

storedProcedureParameters?: any

Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".

type

type

Polymorphic discriminator, which specifies the different types this object can be

OptionaluserProperties

userProperties?: UserProperty[]

Activity user properties.

Settings

Member Visibility