docs.ssis_ProjectConnectionList - V

type: V ( view ), modify_date: 2021-11-06 23:01:02

RepoObject_guid: 59BE5C8F-483D-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.ssis_projectconnectionlist

Columns

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

varchar(50)

NOT NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.ssis_projectconnectionlist

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.ssis_projectconnectionlist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.ssis_projectconnectionlist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.ssis_projectconnectionlist

Column Reference Diagram

entity_1_1_colref-docs.ssis_projectconnectionlist

Indexes

idx_ssis_ProjectConnectionList__1

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL

ProjectConnectionList

ProjectConnectionList

nvarchar(max)

NULL

sql_modules_definition

docs.ssis_ProjectConnectionList - V script
CREATE View docs.ssis_ProjectConnectionList
As
Select
    projcon.AntoraModule
  , ProjectConnectionList =
  --
  String_Agg (
                 Concat (
                            Cast(N'' As NVarchar(Max))
                          , '[#connection-'
                          , docs.fs_cleanStringForAnchorId ( projcon.ConnectionManagerName )
                          , ']'
                          , Char ( 13 ) + Char ( 10 )
                          , '=== '
                          , docs.fs_cleanStringForHeader ( projcon.ConnectionManagerName )
                          , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )

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

                          --table content
                          , '|' + 'ConnectionManagerType' + Char ( 13 ) + Char ( 10 ) + '|'
                            + projcon.ConnectionManagerType + Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , '|' + 'ConnectionString' + Char ( 13 ) + Char ( 10 ) + '|' + projcon.ConnectionString
                            + Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , '|' + 'ConnectionManagerID' + Char ( 13 ) + Char ( 10 ) + '|'
                            + Cast(projcon.ConnectionManagerID As NVarchar(50)) + Char ( 13 ) + Char ( 10 )
                            + Char ( 13 ) + Char ( 10 )
                          , '|' + 'ConnectionPath' + Char ( 13 ) + Char ( 10 ) + '|' + projcon.ConnectionPath
                            + Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , Iif(projcon.ExpressionValue <> ''
                              , '|' + 'ExpressionValue' + Char ( 13 ) + Char ( 10 ) + '|' + projcon.ExpressionValue
                                + Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                              , '')
                          --, '|' + 'RetainSameConnectionProperty' + Char ( 13 ) + Char ( 10 ) + '|'
                          --  + RetainSameConnectionProperty + Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )

                          --table end
                          , '|===' + Char ( 13 ) + Char ( 10 )
                        )
               , Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                projcon.ConnectionManagerName)
From
    ssis.ProjectConnection As projcon
Group By
    projcon.AntoraModule