docs.ssis_PumlPartialDataFlow - V

Description

Examples

Entity Diagram

Columns

Table 1. Columns of docs.ssis_PumlPartialDataFlow - V
Column Name	Data Type	NULL?
AntoraModule	`varchar(50)`	`NOT NULL`
PackageName	`varchar(200)`	`NOT NULL`
PumlPartialDataFlow	`nvarchar(max)`	`NULL`
TaskFromParent	`varchar(2000)`	`NULL`

Foreign Key Diagram

References

Referenced Objects

Referencing Objects

docs.ssis_PumlDftTask - V

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Column Details

_

AntoraModule

varchar(50)

NOT NULL

Referenced Columns

ssis.PackageFlow.AntoraModule

PackageName

varchar(200)

NOT NULL

Referenced Columns

ssis.PackageFlow.PackageName

PumlPartialDataFlow

nvarchar(max)

NULL

TaskFromParent

varchar(2000)

NULL

Description

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

Referenced Columns

ssis.PackageFlow.TaskFromParent

sql_modules_definition

docs.ssis_PumlPartialDataFlow - V script

CREATE View docs.ssis_PumlPartialDataFlow
As
Select
    pf.AntoraModule
  , pf.PackageName
  , pf.TaskFromParent
  , PumlPartialDataFlow =
  --
  String_Agg (
                 Cast(N'' As NVarchar(Max)) + docs.fs_cleanStringForAnchorId ( pf.TaskFrom ) + ' --> '
                 + docs.fs_cleanStringForAnchorId ( pf.Taskto ) + Iif(pf.Expression <> '', ' : ' + pf.Expression, '')
               , Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                pf.TaskFrom
                              , pf.Taskto)
From
    ssis.PackageFlow As pf
Where
    pf.FlowType = 'Data Flow'
Group By
    pf.AntoraModule
  , pf.PackageName
  , pf.TaskFromParent

sql