ssis.PackageFlow_src - V

type: V ( view ), modify_date: 2021-11-01 14:35:28

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

Description

Examples

Entity Diagram

entity-ssis.packageflow_src

Columns

Table 1. Columns of ssis.PackageFlow_src - V
PK Column Name Data Type NULL? ID

1

varchar(50)

NOT NULL

2

varchar(200)

NULL

3

varchar(2000)

NULL

4

varchar(2000)

NULL

nvarchar(max)

NULL

uniqueidentifier

NULL

int

NULL

nvarchar(max)

NULL

varchar(1000)

NULL

bit

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis.packageflow_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packageflow_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packageflow_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packageflow_src

Column Reference Diagram

entity_1_1_colref-ssis.packageflow_src

Indexes

PK_PackageFlow_src

idx_PackageFlow_src__2

idx_PackageFlow_src__3

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

Referenced Columns
Referencing Columns

PackageName

2

PackageName

varchar(200)

NULL

Description

(left(replace([PackagePath],[ProjectPath]+'\',''),(200)))


Referenced Columns
Referencing Columns

TaskFrom

3

TaskFrom

varchar(2000)

NULL

Referencing Columns

Taskto

4

Taskto

varchar(2000)

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

sql_modules_definition

ssis.PackageFlow_src - V script
CREATE View [ssis].[PackageFlow_src]
As
Select
    p.AntoraModule
  , p.PackageName
  , T2.TaskFrom
  , T2.TaskTo
  , T2.FlowType
  , T2.LogicalAnd
  , T2.ObjectName
  , T2.CreationName
  , T2.DTSID
  , T2.EvalOp
  , T2.Expression
From
    ssis.Package_src                   As p
    Inner Join
        ssis_t.TblPrecedenceConstraint As T2
            On
            p.RowID = T2.RowID