ssis.PackageTask - U

type: U ( user table ), modify_date: 2022-09-05 18:18:08

RepoObject_guid: 6264FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.packagetask

Columns

Table 1. Columns of ssis.PackageTask - U
PK Column Name Data Type NULL? ID

AntoraModule

varchar(50)

NOT NULL

ControlFlowDetailsRowID

int

NOT NULL

DelayValidationPropertyValue

varchar(100)

NULL

ExecutedPackageName

varchar(1000)

NULL

ExecutePackageConnection

varchar(1000)

NULL

ExecutePackageExpression

varchar(1000)

NULL

ExpressionValue

varchar(5000)

NULL

IsDisabled

varchar(10)

NULL

PackageName

varchar(200)

NOT NULL

Script

varchar(max)

NULL

SqlConnection

uniqueidentifier

NULL

SqlStatementSource

nvarchar(max)

NULL

TaskDescription

varchar(max)

NULL

TaskName

varchar(2000)

NOT NULL

TaskPath

varchar(8000)

NOT NULL

TaskType

varchar(5000)

NULL

PackageBasename

Definition (PERSISTED)
(replace([PackageName],'.dtsx',''))

varchar(8000)

NULL

TaskPathLevel

Definition (PERSISTED)
(len([TaskPath])-len(replace([TaskPath],'\','')))

int

NULL

TaskPathParent

Definition (PERSISTED)
(substring([TaskPath],(1),len([TaskPath])-charindex('\',reverse([TaskPath]))))

varchar(8000)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis.packagetask

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packagetask

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packagetask

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packagetask

Column Reference Diagram

entity_1_1_colref-ssis.packagetask

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL
Referencing Columns

ControlFlowDetailsRowID

ControlFlowDetailsRowID

int

NOT NULL
Referencing Columns

DelayValidationPropertyValue

DelayValidationPropertyValue

varchar(100)

NULL
Referencing Columns

ExecutedPackageName

ExecutedPackageName

varchar(1000)

NULL
Referencing Columns

ExecutePackageConnection

ExecutePackageConnection

varchar(1000)

NULL
Referencing Columns

ExecutePackageExpression

ExecutePackageExpression

varchar(1000)

NULL
Referencing Columns

ExpressionValue

ExpressionValue

varchar(5000)

NULL
Referencing Columns

IsDisabled

IsDisabled

varchar(10)

NULL
Referencing Columns

PackageName

PackageName

varchar(200)

NOT NULL
Referencing Columns

Script

Script

varchar(max)

NULL
Referencing Columns

SqlConnection

SqlConnection

uniqueidentifier

NULL
Referencing Columns

SqlStatementSource

SqlStatementSource

nvarchar(max)

NULL
Referencing Columns

TaskDescription

TaskDescription

varchar(max)

NULL
Referencing Columns

TaskName

TaskName

varchar(2000)

NOT NULL
Referencing Columns

TaskPath

TaskPath

varchar(8000)

NOT NULL
Referencing Columns

TaskType

TaskType

varchar(5000)

NULL
Referencing Columns

PackageBasename

PackageBasename

Definition (PERSISTED)
(replace([PackageName],'.dtsx',''))

varchar(8000)

NULL
Description

(replace([PackageName],'.dtsx',''))


Referenced Columns
Referencing Columns

TaskPathLevel

TaskPathLevel

Definition (PERSISTED)
(len([TaskPath])-len(replace([TaskPath],'\','')))

int

NULL
Description

(len([TaskPath])-len(replace([TaskPath],'\','')))


Referenced Columns
Referencing Columns

TaskPathParent

TaskPathParent

Definition (PERSISTED)
(substring([TaskPath],(1),len([TaskPath])-charindex('\',reverse([TaskPath]))))

varchar(8000)

NULL
Description

(substring([TaskPath],(1),len([TaskPath])-charindex('\',reverse([TaskPath]))))


Referenced Columns
Referencing Columns