docs.ssis_DftTaskComponentOutputColumnList - V

type: V ( view ), modify_date: 2021-11-09 08:53:51

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

Description

Examples

Entity Diagram

entity-docs.ssis_dfttaskcomponentoutputcolumnlist

Columns

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

varchar(50)

NOT NULL

varchar(max)

NULL

nvarchar(max)

NOT NULL

varchar(max)

NULL

varchar(200)

NULL

varchar(8000)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.ssis_dfttaskcomponentoutputcolumnlist

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.ssis_dfttaskcomponentoutputcolumnlist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.ssis_dfttaskcomponentoutputcolumnlist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.ssis_dfttaskcomponentoutputcolumnlist

Column Reference Diagram

entity_1_1_colref-docs.ssis_dfttaskcomponentoutputcolumnlist

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL

Component_refId

Component_refId

varchar(max)

NULL

DftTaskComponentOutputColumnList

DftTaskComponentOutputColumnList

nvarchar(max)

NOT NULL

output_refId

output_refId

varchar(max)

NULL

PackageName

PackageName

varchar(200)

NULL

TaskPath

TaskPath

varchar(8000)

NULL

sql_modules_definition

docs.ssis_DftTaskComponentOutputColumnList - V script
CREATE View [docs].[ssis_DftTaskComponentOutputColumnList]
As
Select
    T1.AntoraModule
  , T1.PackageName
  , T1.TaskPath
  , T1.Component_refId
  , T1.output_refId
  , DftTaskComponentOutputColumnList =
  --
  Concat (
             N''
           --table start
           , '.Columns of ' + T1.output_refId + Char ( 13 ) + Char ( 10 )
           , '[cols="2,1l,2l"]' + Char ( 13 ) + Char ( 10 )
           , '|===' + Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 )
           --
           --table content
           , String_Agg (
                            Concat (
                                       Cast(N'' As NVarchar(Max))
                                     --inline Anchor ID sysntax:
                                     --[[bookmark-a]]Inline anchors make arbitrary content referenceable.
                                     --not working:
                                     --[#bookmark-b]#Inline anchors can be applied to a phrase like this one.#
                                     , '|' + '[[dftcomponentcolumn-'
                                       + docs.fs_cleanStringForAnchorId ( T1.Column_refId ) + ']]'
                                     , docs.fs_cleanStringForHeader ( T1.Column_Name )
                                     , Iif(T2.Column_name <> T1.Column_name, ' (' + T2.Column_name + ')', '')
                                     , Char ( 13 ) + Char ( 10 )
                                     , '|' + T1.Column_dataType
                                     , '(' + Cast(T1.Column_length As Varchar(10)) + ')'
                                     , '(' + Cast(T1.Column_precision As Varchar(10)) + ','
                                     , Cast(T1.Column_scale As Varchar(10)) + ')'
                                     , Iif(
                                           T2.Column_dataType <> T1.Column_dataType
                                           Or T2.Column_length <> T1.Column_length
                                           Or T2.Column_precision <> T1.Column_precision
                                           Or T2.Column_scale <> T1.Column_scale
                                         , Concat (
                                                      ' - '
                                                    , T2.Column_dataType
                                                    , '(' + Cast(T2.Column_length As Varchar(10)) + ')'
                                                    , '(' + Cast(T2.Column_precision As Varchar(10)) + ','
                                                    , Cast(T2.Column_scale As Varchar(10)) + ')'
                                                  )
                                         , '')
                                     , Char ( 13 ) + Char ( 10 )
                                     , '|'
                                     , T1.Column_errorOrTruncationOperation + ', '
                                     , T1.Column_errorRowDisposition + ', '
                                     , T1.Column_truncationRowDisposition + ', '
                                     , Char ( 13 ) + Char ( 10 )
                                   --, '|'
                                   --, ' <<dftcomponentcolumn-'
                                   --  + docs.fs_cleanStringForAnchorId ( T1.Column_externalMetadataColumnId ) + '>>'
                                   --, Char ( 13 ) + Char ( 10 )
                                   )
                          , Char ( 13 ) + Char ( 10 )
                        ) Within Group(Order By
                                           T1.Column_refId)

           --table end
           , '|===' + Char ( 13 ) + Char ( 10 )
         )
From
    ssis.PackageTask_Dft_Component_output_outputcolumn              As T1
    Left Join
        ssis.PackageTask_Dft_Component_input_externalMetadataColumn As T2
            On
            T2.AntoraModule     = T1.AntoraModule
            And T2.PackageName  = T1.PackageName
            And T2.Column_refId = T1.Column_externalMetadataColumnId
Group By
    T1.AntoraModule
  , T1.PackageName
  , T1.TaskPath
  , T1.Component_refId
  , T1.output_refId