ssis.Package - U

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

RepoObject_guid: 5464FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.package

Columns

Table 1. Columns of ssis.Package - U
PK Column Name Data Type NULL? ID

1

varchar(50)

NOT NULL

2

varchar(200)

NOT NULL

datetime

NULL

nvarchar(500)

NULL

varchar(1000)

NULL

nvarchar(max)

NULL

uniqueidentifier

NOT NULL

nvarchar(500)

NULL

int

NULL

nvarchar(500)

NULL

varchar(8000)

NOT NULL

varchar(100)

NULL

varchar(28)

NULL

uniqueidentifier

NULL

varchar(8000)

NOT NULL

int

NOT NULL

Definition (PERSISTED)
(replace([PackageName],'.dtsx',''))

varchar(8000)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis.package

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.package

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.package

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.package

Column Reference Diagram

entity_1_1_colref-ssis.package

Indexes

PK_Package

Column Details

_

PackageName

2

PackageName

varchar(200)

NOT NULL

PackageCreationDate

PackageCreationDate

datetime

NULL

PackageCreatorComputerName

PackageCreatorComputerName

nvarchar(500)

NULL

PackageCreatorName

PackageCreatorName

varchar(1000)

NULL

PackageDescription

PackageDescription

nvarchar(max)

NULL

PackageDTSID

PackageDTSID

uniqueidentifier

NOT NULL

Referencing Columns

PackageLastModifiedProductVersion

PackageLastModifiedProductVersion

nvarchar(500)

NULL

PackageLocaleID

PackageLocaleID

int

NULL

Referencing Columns

PackageObjectName

PackageObjectName

nvarchar(500)

NULL

PackagePath

PackagePath

varchar(8000)

NOT NULL

Referencing Columns

PackageProtectionLevel

PackageProtectionLevel

varchar(100)

NULL

PackageProtectionLevelName

PackageProtectionLevelName

varchar(28)

NULL

PackageVersionGUID

PackageVersionGUID

uniqueidentifier

NULL

ProjectPath

ProjectPath

varchar(8000)

NOT NULL

Referencing Columns

RowID

RowID

int

NOT NULL

Referencing Columns

PackageBasename

PackageBasename

Definition (PERSISTED)
(replace([PackageName],'.dtsx',''))

varchar(8000)

NULL

Description

(replace([PackageName],'.dtsx',''))


Referenced Columns
Referencing Columns