ssis_t.PackageDetails - V

type: V ( view ), modify_date: 2021-11-01 13:46:40

RepoObject_guid: 5B64FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis_t.packagedetails

Columns

Table 1. Columns of ssis_t.PackageDetails - V
PK Column Name Data Type NULL? ID

datetime

NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

uniqueidentifier

NULL

nvarchar(500)

NULL

int

NULL

nvarchar(500)

NULL

varchar(8000)

NOT NULL

nvarchar(500)

NULL

uniqueidentifier

NULL

int

NOT NULL

Foreign Key Diagram

entity_1_1_fk-ssis_t.packagedetails

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis_t.packagedetails

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis_t.packagedetails

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis_t.packagedetails

Column Reference Diagram

entity_1_1_colref-ssis_t.packagedetails

Indexes

idx_PackageDetails__1

Column Details

_

PackageCreationDate

PackageCreationDate

datetime

NULL

Referenced Columns

PackageCreatorComputerName

PackageCreatorComputerName

nvarchar(500)

NULL

Referenced Columns

PackageCreatorName

PackageCreatorName

nvarchar(500)

NULL

Referenced Columns

PackageDescription

PackageDescription

nvarchar(max)

NULL

Referenced Columns

PackageDTSID

PackageDTSID

uniqueidentifier

NULL

Referenced Columns

PackageLastModifiedProductVersion

PackageLastModifiedProductVersion

nvarchar(500)

NULL

Referenced Columns

PackageLocaleID

PackageLocaleID

int

NULL

Referenced Columns

PackageObjectName

PackageObjectName

nvarchar(500)

NULL

Referenced Columns

PackagePath

PackagePath

varchar(8000)

NOT NULL

Referenced Columns

PackageProtectionLevel

PackageProtectionLevel

nvarchar(500)

NULL

Referenced Columns

PackageVersionGUID

PackageVersionGUID

uniqueidentifier

NULL

Referenced Columns

RowID

RowID

int

NOT NULL

Referenced Columns

sql_modules_definition

ssis_t.PackageDetails - V script
CREATE VIEW [ssis_t].[PackageDetails]
As
Select
    pkg.RowID
  , pkg.PackagePath
  , PackageObjectName                 = pkg.PackageXML.value (
                                                                 'declare namespace DTS="www.microsoft.com/SqlServer/Dts";
					/DTS:Executable[1]/@DTS:ObjectName'
                                                               , 'nvarchar(500)'
                                                             )
  , PackageCreationDate               = pkg.PackageXML.value (
                                                                 'declare namespace DTS="www.microsoft.com/SqlServer/Dts";
					/DTS:Executable[1]/@DTS:CreationDate'
                                                               , 'datetime'
                                                             )
  , PackageCreatorComputerName        = pkg.PackageXML.value (
                                                                 'declare namespace DTS="www.microsoft.com/SqlServer/Dts";
					/DTS:Executable[1]/@DTS:CreatorComputerName'
                                                               , 'nvarchar(500)'
                                                             )
  , PackageCreatorName                = pkg.PackageXML.value (
                                                                 'declare namespace DTS="www.microsoft.com/SqlServer/Dts";
					/DTS:Executable[1]/@DTS:CreatorName'
                                                               , 'nvarchar(500)'
                                                             )
  , PackageDescription                = pkg.PackageXML.value (
                                                                 'declare namespace DTS="www.microsoft.com/SqlServer/Dts";
					/DTS:Executable[1]/@DTS:Description'
                                                               , 'nvarchar(max)'
                                                             )
  , PackageDTSID                      = pkg.PackageXML.value (
                                                                 'declare namespace DTS="www.microsoft.com/SqlServer/Dts";
					/DTS:Executable[1]/@DTS:DTSID'
                                                               , 'uniqueidentifier'
                                                             )
  , PackageProtectionLevel            = pkg.PackageXML.value (
                                                                 'declare namespace DTS="www.microsoft.com/SqlServer/Dts";
					/DTS:Executable[1]/@DTS:ProtectionLevel'
                                                               , 'nvarchar(500)'
                                                             )
  , PackageVersionGUID                = pkg.PackageXML.value (
                                                                 'declare namespace DTS="www.microsoft.com/SqlServer/Dts";
					/DTS:Executable[1]/@DTS:VersionGUID'
                                                               , 'uniqueidentifier'
                                                             )
  , PackageLocaleID                   = pkg.PackageXML.value (
                                                                 'declare namespace DTS="www.microsoft.com/SqlServer/Dts";
					/DTS:Executable[1]/@DTS:LocaleID'
                                                               , 'int'
                                                             )
  , PackageLastModifiedProductVersion = pkg.PackageXML.value (
                                                                 'declare namespace DTS="www.microsoft.com/SqlServer/Dts";
					/DTS:Executable[1]/@DTS:LastModifiedProductVersion'
                                                               , 'nvarchar(500)'
                                                             )
From
    ssis_t.pkgStats As pkg