ssis.Package_tgt - V :: DataHandwerk Docs

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssis.Package_tgt - V
PK	Column Name	Data Type	NULL?
1	AntoraModule	`varchar(50)`	`NOT NULL`
2	PackageName	`varchar(200)`	`NOT NULL`
	PackageCreationDate	`datetime`	`NULL`
	PackageCreatorComputerName	`nvarchar(500)`	`NULL`
	PackageCreatorName	`varchar(1000)`	`NULL`
	PackageDescription	`nvarchar(max)`	`NULL`
	PackageDTSID	`uniqueidentifier`	`NOT NULL`
	PackageLastModifiedProductVersion	`nvarchar(500)`	`NULL`
	PackageLocaleID	`int`	`NULL`
	PackageObjectName	`nvarchar(500)`	`NULL`
	PackagePath	`varchar(8000)`	`NOT NULL`
	PackageProtectionLevel	`varchar(100)`	`NULL`
	PackageProtectionLevelName	`varchar(28)`	`NULL`
	PackageVersionGUID	`uniqueidentifier`	`NULL`
	ProjectPath	`varchar(8000)`	`NOT NULL`
	RowID	`int`	`NOT NULL`

Persistence, History Table

persistence source: ssis.Package_src - V
is_persistence: 1
is_persistence_check_duplicate_per_pk: 0
is_persistence_check_for_empty_source: 0
is_persistence_delete_changed: 0
is_persistence_delete_missing: 1
is_persistence_insert: 1
is_persistence_truncate: 0
is_persistence_update_changed: 1
has_history: 0
has_history_columns: 0

Foreign Key Diagram

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

PK_Package_tgt

IndexSemanticGroup: no_group
- [column-AntoraModule]; varchar(50)
- [column-PackageName]; varchar(200)
PK, Unique, Real: 1, 1, 0

idx_Package_tgt__2

IndexSemanticGroup: no_group
- [column-RowID]; int
PK, Unique, Real: 0, 0, 0

idx_Package_tgt__3

IndexSemanticGroup: no_group
- [column-AntoraModule]; varchar(50)
PK, Unique, Real: 0, 0, 0

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

Referenced Columns

PackageName

2

PackageName

varchar(200)

NOT NULL

Referenced Columns

PackageCreationDate

datetime

NULL

Referenced Columns

PackageCreatorComputerName

nvarchar(500)

NULL

Referenced Columns

PackageCreatorName

varchar(1000)

NULL

Referenced Columns

PackageDescription

nvarchar(max)

NULL

Referenced Columns

PackageDTSID

uniqueidentifier

NOT NULL

Referenced Columns

PackageLastModifiedProductVersion

nvarchar(500)

NULL

Referenced Columns

PackageLocaleID

int

NULL

Referenced Columns

PackageObjectName

nvarchar(500)

NULL

Referenced Columns

PackagePath

varchar(8000)

NOT NULL

Referenced Columns

PackageProtectionLevel

varchar(100)

NULL

Referenced Columns

PackageProtectionLevelName

varchar(28)

NULL

Referenced Columns

PackageVersionGUID

uniqueidentifier

NULL

Referenced Columns

ProjectPath

varchar(8000)

NOT NULL

Referenced Columns

RowID

int

NOT NULL

Referenced Columns

sql_modules_definition

ssis.Package_tgt - V script

CREATE VIEW [ssis].[Package_tgt]
As
Select
    tgt.AntoraModule
  , tgt.PackageName
  , tgt.PackageDTSID
  , tgt.PackageCreationDate
  , tgt.PackageCreatorComputerName
  , tgt.PackageCreatorName
  , tgt.PackageDescription
  , tgt.PackageLastModifiedProductVersion
  , tgt.PackageLocaleID
  , tgt.PackageObjectName
  , tgt.PackagePath
  , tgt.PackageProtectionLevel
  , tgt.PackageProtectionLevelName
  , tgt.PackageVersionGUID
  --, tgt.PackageXML
  , tgt.ProjectPath
  , tgt.RowID
From
    ssis.Package As tgt
Where
    Exists
(
    Select
        1
    From
        ssis.AntoraModule_tgt_filter As f
    Where
        tgt.AntoraModule = f.AntoraModule
)