docs.ssis_PumlDftTask - V

type: V ( view ), modify_date: 2021-11-10 10:02:53

RepoObject_guid: 73CC7FC6-CF3F-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.ssis_pumldfttask

Columns

Table 1. Columns of docs.ssis_PumlDftTask - V
PK Column Name Data Type NULL? ID

varchar(50)

NOT NULL

varchar(200)

NOT NULL

nvarchar(max)

NOT NULL

varchar(8000)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-docs.ssis_pumldfttask

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.ssis_pumldfttask

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.ssis_pumldfttask

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.ssis_pumldfttask

Column Reference Diagram

entity_1_1_colref-docs.ssis_pumldfttask

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL

PackageName

PackageName

varchar(200)

NOT NULL

PumlDftTask

PumlDftTask

nvarchar(max)

NOT NULL

TaskPath

TaskPath

varchar(8000)

NOT NULL

sql_modules_definition

docs.ssis_PumlDftTask - V script
CREATE View docs.ssis_PumlDftTask
As
Select
    T1.AntoraModule
  , T1.PackageName
  , T1.TaskPath
  , PumlDftTask =
  --
  Concat (
             Cast(N'' As NVarchar(Max))
           , '@startuml
'
           , 'frame "' + T1.TaskPath + '" {
'
           , String_Agg ( Cast(T2.PumlPartialDftComponent As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                                         T1.Component_refId)
           , '
}

'
           , Max ( T3.PumlPartialDataFlow )
           --
           , Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + Max ( puml_footer.Parameter_value_result )
             + Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 ) + '@enduml' + Char ( 13 ) + Char ( 10 )
         )
From
    ssis.PackageTask_Dft_Component                                             As T1
    Left Join
        docs.ssis_PumlPartialDftComponent                                      As T2
            On
            T2.AntoraModule = T1.AntoraModule
            And T2.PackageName = T1.PackageName
            And T2.TaskPath = T1.TaskPath
            And T2.Component_refId = T1.Component_refId

    Left Join
        docs.ssis_PumlPartialDataFlow                                          As T3
            On
            T3.AntoraModule = T1.AntoraModule
            And T3.PackageName = T1.PackageName
            And T3.TaskFromParent = T1.TaskPath
    Cross Join config.ftv_get_parameter_value ( 'puml_footer', 'interactive' ) As puml_footer
Group By
    T1.AntoraModule
  , T1.PackageName
  , T1.TaskPath