ssis_t.pkgStats - U

type: U ( user table ), modify_date: 2022-09-05 18:18:08

RepoObject_guid: 7A64FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis_t.pkgstats

Columns

Table 1. Columns of ssis_t.pkgStats - U
PK Column Name Data Type NULL? ID

1

RowID

int

NOT NULL

(1,1)

PackageCreationDate

datetime

NULL

PackageCreatorComputerName

nvarchar(500)

NULL

PackageCreatorName

varchar(1000)

NULL

PackageDescription

nvarchar(max)

NULL

PackageDTSID

uniqueidentifier

NULL

PackageLastModifiedProductVersion

nvarchar(500)

NULL

PackageLocaleID

int

NULL

PackageObjectName

nvarchar(500)

NULL

PackagePath

varchar(8000)

NOT NULL

PackageProtectionLevel

varchar(100)

NULL

PackageVersionGUID

uniqueidentifier

NULL

PackageXML

xml

NOT NULL

ProjectPath

varchar(8000)

NOT NULL

PackageName

Definition (PERSISTED)
(left(replace([PackagePath],[ProjectPath]+'\',''),(200)))

varchar(200)

NULL

PackageProtectionLevelName

Definition
(case [PackageProtectionLevel] when '0' then 'DontSaveSensitive' when '1' then 'EncryptSensitiveWithUserKey' when '2' then 'EncryptSensitiveWithPassword' when '3' then 'EncryptAllWithPassword' when '4' then 'EncryptAllWithUserKey' when '5' then 'ServerStorage'  end)

varchar(28)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis_t.pkgstats

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis_t.pkgstats

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis_t.pkgstats

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis_t.pkgstats

Column Reference Diagram

entity_1_1_colref-ssis_t.pkgstats

Indexes

PK__pkgStats__FFEE7451CEB89CD7

Column Details

_

RowID

1

RowID

int

NOT NULL

(1,1)
Referencing Columns

PackageCreationDate

PackageCreationDate

datetime

NULL
Referencing Columns

PackageCreatorComputerName

PackageCreatorComputerName

nvarchar(500)

NULL
Referencing Columns

PackageCreatorName

PackageCreatorName

varchar(1000)

NULL
Referencing Columns

PackageDescription

PackageDescription

nvarchar(max)

NULL
Referencing Columns

PackageDTSID

PackageDTSID

uniqueidentifier

NULL
Referencing Columns

PackageLastModifiedProductVersion

PackageLastModifiedProductVersion

nvarchar(500)

NULL
Referencing Columns

PackageLocaleID

PackageLocaleID

int

NULL
Referencing Columns

PackageObjectName

PackageObjectName

nvarchar(500)

NULL
Referencing Columns

PackagePath

PackagePath

varchar(8000)

NOT NULL
Referencing Columns

PackageProtectionLevel

PackageProtectionLevel

varchar(100)

NULL
Referencing Columns

PackageVersionGUID

PackageVersionGUID

uniqueidentifier

NULL
Referencing Columns

PackageXML

PackageXML

xml

NOT NULL
Referencing Columns

ProjectPath

ProjectPath

varchar(8000)

NOT NULL
Referencing Columns

PackageName

PackageName

Definition (PERSISTED)
(left(replace([PackagePath],[ProjectPath]+'\',''),(200)))

varchar(200)

NULL
Description

(left(replace([PackagePath],[ProjectPath]+'\',''),(200)))


Referenced Columns
Referencing Columns

PackageProtectionLevelName

PackageProtectionLevelName

Definition
(case [PackageProtectionLevel] when '0' then 'DontSaveSensitive' when '1' then 'EncryptSensitiveWithUserKey' when '2' then 'EncryptSensitiveWithPassword' when '3' then 'EncryptAllWithPassword' when '4' then 'EncryptAllWithUserKey' when '5' then 'ServerStorage'  end)

varchar(28)

NULL
Description

(case [PackageProtectionLevel] when '0' then 'DontSaveSensitive' when '1' then 'EncryptSensitiveWithUserKey' when '2' then 'EncryptSensitiveWithPassword' when '3' then 'EncryptAllWithPassword' when '4' then 'EncryptAllWithUserKey' when '5' then 'ServerStorage' end)


Referenced Columns
Referencing Columns