docs.ssis_PackageConnectionList - V
type: V ( view ), modify_date: 2021-11-29 20:40:21
RepoObject_guid: 859A07F7-C23C-EC11-852D-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
Indexes
idx_ssis_PackageConnectionList__1
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
-
PK, Unique, Real: 0, 0, 0
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