ssis.PackageFlow - U

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

RepoObject_guid: 5C64FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.packageflow

Columns

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

AntoraModule

varchar(50)

NOT NULL

CreationName

nvarchar(max)

NULL

DTSID

uniqueidentifier

NULL

EvalOp

int

NULL

Expression

nvarchar(max)

NULL

FlowType

varchar(1000)

NULL

LogicalAnd

bit

NULL

ObjectName

nvarchar(max)

NULL

PackageName

varchar(200)

NOT NULL

TaskFrom

varchar(2000)

NOT NULL

Taskto

varchar(2000)

NOT NULL

TaskFromLevel

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

int

NULL

TaskFromParent

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

varchar(2000)

NULL

TaskToLevel

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

int

NULL

TaskToParent

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

varchar(2000)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis.packageflow

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packageflow

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packageflow

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packageflow

Column Reference Diagram

entity_1_1_colref-ssis.packageflow

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL
Referencing Columns

CreationName

CreationName

nvarchar(max)

NULL
Referencing Columns

DTSID

DTSID

uniqueidentifier

NULL
Referencing Columns

EvalOp

EvalOp

int

NULL
Referencing Columns

Expression

Expression

nvarchar(max)

NULL
Referencing Columns

FlowType

FlowType

varchar(1000)

NULL
Referencing Columns

LogicalAnd

LogicalAnd

bit

NULL
Referencing Columns

ObjectName

ObjectName

nvarchar(max)

NULL
Referencing Columns

PackageName

PackageName

varchar(200)

NOT NULL
Referencing Columns

TaskFrom

TaskFrom

varchar(2000)

NOT NULL
Referencing Columns

Taskto

Taskto

varchar(2000)

NOT NULL
Referencing Columns

TaskFromLevel

TaskFromLevel

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

int

NULL
Description

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


Referenced Columns

TaskFromParent

TaskFromParent

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

varchar(2000)

NULL
Description

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


Referenced Columns
Referencing Columns

TaskToLevel

TaskToLevel

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

int

NULL
Description

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


Referenced Columns

TaskToParent

TaskToParent

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

varchar(2000)

NULL
Description

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


Referenced Columns