docs.ssis_GeneralList - V

type: V ( view ), modify_date: 2021-11-03 18:52:07

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

Description

Examples

Entity Diagram

entity-docs.ssis_generallist

Columns

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

varchar(50)

NOT NULL

nvarchar(max)

NOT NULL

varchar(200)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-docs.ssis_generallist

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.ssis_generallist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.ssis_generallist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.ssis_generallist

Column Reference Diagram

entity_1_1_colref-docs.ssis_generallist

Indexes

idx_ssis_GeneralList__1

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL

Referenced Columns

GeneralList

GeneralList

nvarchar(max)

NOT NULL

PackageName

PackageName

varchar(200)

NOT NULL

Referenced Columns

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