docs.ssis_PackageConnectionList - V

type: V ( view ), modify_date: 2021-11-29 20:40:21

RepoObject_guid: 859A07F7-C23C-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.ssis_packageconnectionlist

Columns

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

varchar(50)

NOT NULL

nvarchar(max)

NULL

varchar(200)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-docs.ssis_packageconnectionlist

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.ssis_packageconnectionlist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.ssis_packageconnectionlist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.ssis_packageconnectionlist

Column Reference Diagram

entity_1_1_colref-docs.ssis_packageconnectionlist

Indexes

idx_ssis_PackageConnectionList__1

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL

PackageConnectionList

PackageConnectionList

nvarchar(max)

NULL

PackageName

PackageName

varchar(200)

NOT NULL

sql_modules_definition

docs.ssis_PackageConnectionList - V script
CREATE View docs.ssis_PackageConnectionList
As
Select
    AntoraModule
  , PackageName
  , PackageConnectionList =
  --
  String_Agg (
                 Concat (
                            Cast(N'' As NVarchar(Max))
                          , '[#connection-'
                          , docs.fs_cleanStringForAnchorId ( ConnectionManagerName )
                          , ']'
                          , Char ( 13 ) + Char ( 10 )
                          , '=== '
                          , docs.fs_cleanStringForHeader ( 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 ) + '|' + ConnectionManagerType
                            + Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , '|' + 'ConnectionString' + Char ( 13 ) + Char ( 10 ) + '|' + ConnectionString + Char ( 13 )
                            + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , '|' + 'Package Link' + Char ( 13 ) + Char ( 10 ) + 'a|' + 'xref:'
                            + docs.fs_cleanStringForFilename ( DtsPackageBaseName ) + '.adoc[]' + Char ( 13 )
                            + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
                          , '|' + 'ConnectionManagerID' + Char ( 13 ) + Char ( 10 ) + '|'
                            + Cast(ConnectionManagerID As NVarchar(50)) + Char ( 13 ) + Char ( 10 ) + Char ( 13 )
                            + Char ( 10 )
                          , '|' + 'ExpressionValue' + Char ( 13 ) + Char ( 10 ) + '|' + 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
                                ConnectionManagerName)
From
    ssis.PackageConnection
Group By
    AntoraModule
  , PackageName