docs.ssis_GeneralList - V
type: V ( view ), modify_date: 2021-11-03 18:52:07
RepoObject_guid: 58BE5C8F-483D-EC11-852D-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
Indexes
idx_ssis_GeneralList__1
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
-
PK, Unique, Real: 0, 0, 0
sql_modules_definition
docs.ssis_GeneralList - V script
CREATE View docs.ssis_GeneralList
As
Select
AntoraModule
, PackageName
, GeneralList =
--
Concat (
Cast(N'' As NVarchar(Max))
--table start
, '[cols="1,4l"]' + Char ( 13 ) + Char ( 10 )
, '|===' + Char ( 13 ) + Char ( 10 )
, Char ( 13 ) + Char ( 10 )
--table content
, '|' + 'PackageCreationDate' + Char ( 13 ) + Char ( 10 ) + '|'
+ Convert ( NVarchar(50), PackageCreationDate, 120 ) + Char ( 13 ) + Char ( 10 ) + Char ( 13 )
+ Char ( 10 )
, '|' + 'PackageCreatorComputerName' + Char ( 13 ) + Char ( 10 ) + '|' + PackageCreatorComputerName
+ Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
, '|' + 'PackageCreatorName' + Char ( 13 ) + Char ( 10 ) + '|' + PackageCreatorName + Char ( 13 )
+ Char ( 10 ) + Char ( 13 ) + Char ( 10 )
, '|' + 'PackageDTSID' + Char ( 13 ) + Char ( 10 ) + '|' + Cast(PackageDTSID As NVarchar(50)) + Char ( 13 )
+ Char ( 10 ) + Char ( 13 ) + Char ( 10 )
, '|' + 'PackageLastModifiedProductVersion' + Char ( 13 ) + Char ( 10 ) + '|'
+ PackageLastModifiedProductVersion + Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
, '|' + 'PackageLocaleID' + Char ( 13 ) + Char ( 10 ) + '|' + Cast(PackageLocaleID As NVarchar(50))
+ Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
--, '|' + 'PackagePath' + Char ( 13 ) + Char ( 10 ) + '|' + PackagePath + Char ( 13 ) + Char ( 10 )
-- + Char ( 13 ) + Char ( 10 )
, '|' + 'PackageProtectionLevel' + Char ( 13 ) + Char ( 10 ) + '|' + PackageProtectionLevel + Char ( 13 )
+ Char ( 10 ) + Char ( 13 ) + Char ( 10 )
, '|' + 'PackageProtectionLevelName' + Char ( 13 ) + Char ( 10 ) + '|' + PackageProtectionLevelName
+ Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
, '|' + 'PackageVersionGUID' + Char ( 13 ) + Char ( 10 ) + '|' + Cast(PackageVersionGUID As NVarchar(50))
+ Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
, '|' + 'ProjectPath' + Char ( 13 ) + Char ( 10 ) + '|' + ProjectPath + Char ( 13 ) + Char ( 10 )
+ Char ( 13 ) + Char ( 10 )
--table end
, '|===' + Char ( 13 ) + Char ( 10 )
)
From
ssis.Package