docs.ssis_VariableList - V
type: V ( view ), modify_date: 2021-11-03 18:27:23
RepoObject_guid: 889A07F7-C23C-EC11-852D-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
Indexes
idx_ssis_VariableList__1
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
-
PK, Unique, Real: 0, 0, 0
sql_modules_definition
docs.ssis_VariableList - V script
CREATE View [docs].[ssis_VariableList]
As
Select
AntoraModule
, PackageName
, VariableList =
--
String_Agg (
Concat (
Cast(N'' As NVarchar(Max))
, '[#variable-'
, docs.fs_cleanStringForAnchorId ( VariableName )
, ']'
, Char ( 13 ) + Char ( 10 )
, '=== '
, docs.fs_cleanStringForHeader ( VariableName )
, 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
--https://docs.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.dts.runtime.wrapper.datatype?view=sqlserver-2019
, '|' + 'VariableDataType' + Char ( 13 ) + Char ( 10 ) + '|' + VariableDataType + Char ( 13 )
+ Char ( 10 ) + Char ( 13 ) + Char ( 10 )
, '|' + 'VariableValue' + Char ( 13 ) + Char ( 10 ) + '|' + VariableValue + Char ( 13 )
+ Char ( 10 ) + Char ( 13 ) + Char ( 10 )
, '|' + 'ExpressionValue' + Char ( 13 ) + Char ( 10 ) + '|' + ExpressionValue + Char ( 13 )
+ Char ( 10 ) + Char ( 13 ) + Char ( 10 )
--table end
, '|===' + Char ( 13 ) + Char ( 10 )
)
, Char ( 13 ) + Char ( 10 )
) Within Group(Order By
VariableName)
From
ssis.PackageVariable
Group By
AntoraModule
, PackageName