ssis.PackageFlow_tgt - V

type: V ( view ), modify_date: 2021-11-01 14:16:58

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

Description

Examples

Entity Diagram

entity-ssis.packageflow_tgt

Columns

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

1

varchar(50)

NOT NULL

2

varchar(200)

NOT NULL

3

varchar(2000)

NOT NULL

4

varchar(2000)

NOT NULL

nvarchar(max)

NULL

uniqueidentifier

NULL

int

NULL

nvarchar(max)

NULL

varchar(1000)

NULL

bit

NULL

nvarchar(max)

NULL

Persistence, History Table

  • persistence source: ssis.PackageFlow_src - V

  • is_persistence: 1

  • is_persistence_check_duplicate_per_pk: 0

  • is_persistence_check_for_empty_source: 0

  • is_persistence_delete_changed: 0

  • is_persistence_delete_missing: 1

  • is_persistence_insert: 1

  • is_persistence_truncate: 0

  • is_persistence_update_changed: 1

  • has_history: 0

  • has_history_columns: 0

Foreign Key Diagram

entity_1_1_fk-ssis.packageflow_tgt

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packageflow_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packageflow_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packageflow_tgt

Column Reference Diagram

entity_1_1_colref-ssis.packageflow_tgt

Indexes

PK_PackageFlow_tgt

idx_PackageFlow_tgt__2

idx_PackageFlow_tgt__3

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

PackageName

2

PackageName

varchar(200)

NOT NULL

TaskFrom

3

TaskFrom

varchar(2000)

NOT NULL

Taskto

4

Taskto

varchar(2000)

NOT NULL

CreationName

CreationName

nvarchar(max)

NULL

DTSID

DTSID

uniqueidentifier

NULL

EvalOp

EvalOp

int

NULL

Expression

Expression

nvarchar(max)

NULL

FlowType

FlowType

varchar(1000)

NULL

LogicalAnd

LogicalAnd

bit

NULL

ObjectName

ObjectName

nvarchar(max)

NULL

sql_modules_definition

ssis.PackageFlow_tgt - V script
CREATE View [ssis].[PackageFlow_tgt]
As
Select
    tgt.AntoraModule
  , tgt.PackageName
  , tgt.TaskFrom
  , tgt.Taskto
  , tgt.FlowType
  , tgt.LogicalAnd
  , tgt.ObjectName
  , tgt.CreationName
  , tgt.DTSID
  , tgt.EvalOp
  , tgt.Expression
From
    ssis.PackageFlow As tgt
Where
    Exists
(
    Select
        1
    From
        ssis.AntoraModule_tgt_filter As f
    Where
        tgt.AntoraModule = f.AntoraModule
)