docs.ssis_DftTaskComponentOutputList - V

type: V ( view ), modify_date: 2021-11-08 14:50:13

RepoObject_guid: D1246838-9F41-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.ssis_dfttaskcomponentoutputlist

Columns

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

varchar(50)

NOT NULL

varchar(max)

NULL

nvarchar(max)

NULL

varchar(200)

NULL

varchar(8000)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.ssis_dfttaskcomponentoutputlist

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.ssis_dfttaskcomponentoutputlist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.ssis_dfttaskcomponentoutputlist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.ssis_dfttaskcomponentoutputlist

Column Reference Diagram

entity_1_1_colref-docs.ssis_dfttaskcomponentoutputlist

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL

Component_refId

Component_refId

varchar(max)

NULL

DftTaskComponentOutputList

DftTaskComponentOutputList

nvarchar(max)

NULL

PackageName

PackageName

varchar(200)

NULL

TaskPath

TaskPath

varchar(8000)

NULL

sql_modules_definition

docs.ssis_DftTaskComponentOutputList - V script
CREATE View [docs].[ssis_DftTaskComponentOutputList]
As
Select
    T1.AntoraModule
  , T1.PackageName
  , T1.TaskPath
  , T1.Component_refId
  , DftTaskComponentOutputList =
  --
  String_Agg (
                 Concat (
                            Cast(N'' As NVarchar(Max))
                          , '[#dftcomponentOutput-'
                          , docs.fs_cleanStringForAnchorId ( T1.output_refId )
                          , ']' + Char ( 13 ) + Char ( 10 )
                          , '[discrete]' + Char ( 13 ) + Char ( 10 )
                          , '===== Output: '
                          , docs.fs_cleanStringForHeader ( T1.Output_name )
                          , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )

                          ----begin collapsible
                          --, '.Output: ' + docs.fs_cleanStringForHeader ( T1.output_name ) + Char ( 13 ) + Char ( 10 )
                          --, '[%collapsible]' + Char ( 13 ) + Char ( 10 )
                          --, '=======' + Char ( 13 ) + Char ( 10 )

                          --table start
                          , '.' + T1.output_refId + Char ( 13 ) + Char ( 10 )
                          , '[cols="1,4l"]' + Char ( 13 ) + Char ( 10 )
                          , '|===' + Char ( 13 ) + Char ( 10 )
                          , Char ( 13 ) + Char ( 10 )

                          --table content
                          , '|' + 'output_isErrorOut' + Char ( 13 ) + Char ( 10 ) + '|'
                            + Cast(IsNull ( T1.output_isErrorOut, 0 ) As Varchar(10)) + Char ( 13 ) + Char ( 10 )
                            + Char ( 13 ) + Char ( 10 )

                          --table end
                          , '|===' + Char ( 13 ) + Char ( 10 )
                          , Char ( 13 ) + Char ( 10 ) + T2.DftTaskComponentOutputColumnList + Char ( 13 ) + Char ( 10 )

                          ----end collapsible
                          --, '=======' + Char ( 13 ) + Char ( 10 )
                        )
               , Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                T1.output_refId)
From
    ssis.PackageTask_Dft_Component_output          As T1
    Left Join
        docs.ssis_DftTaskComponentOutputColumnList As T2
            On
            T2.AntoraModule        = T1.AntoraModule
            And T2.PackageName     = T1.PackageName
            And T2.TaskPath        = T1.TaskPath
            And T2.Component_refId = T1.Component_refId
            And T2.output_refId    = T1.output_refId
Group By
    T1.AntoraModule
  , T1.PackageName
  , T1.TaskPath
  , T1.Component_refId