ssis.PackageConnection_tgt - V :: DataHandwerk Docs

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssis.PackageConnection_tgt - V
PK	Column Name	Data Type	NULL?
1	AntoraModule	`varchar(50)`	`NOT NULL`
2	PackageName	`varchar(200)`	`NOT NULL`
3	ConnectionManagerID	`uniqueidentifier`	`NOT NULL`
	ConnectionManagerName	`varchar(max)`	`NULL`
	ConnectionManagerType	`varchar(max)`	`NULL`
	ConnectionString	`varchar(max)`	`NULL`
	ExpressionValue	`varchar(max)`	`NULL`
	RetainSameConnectionProperty	`nvarchar(max)`	`NULL`

Persistence, History Table

persistence source: ssis.PackageConnection_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_PackageConnection_tgt

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

idx_PackageConnection_tgt__2

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

idx_PackageConnection_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

ConnectionManagerID

3

ConnectionManagerID

uniqueidentifier

NOT NULL

Referenced Columns

ConnectionManagerName

varchar(max)

NULL

Referenced Columns

ConnectionManagerType

varchar(max)

NULL

Referenced Columns

ConnectionString

varchar(max)

NULL

Referenced Columns

ExpressionValue

varchar(max)

NULL

Referenced Columns

RetainSameConnectionProperty

nvarchar(max)

NULL

Referenced Columns

sql_modules_definition

ssis.PackageConnection_tgt - V script

CREATE View [ssis].[PackageConnection_tgt]
As
Select
    tgt.AntoraModule
  , tgt.PackageName
  , tgt.ConnectionManagerID
  , tgt.ConnectionManagerName
  , tgt.ConnectionManagerType
  , tgt.ConnectionString
  , tgt.ExpressionValue
  , tgt.RetainSameConnectionProperty
From
    ssis.PackageConnection As tgt
Where
    Exists
(
    Select
        1
    From
        ssis.AntoraModule_tgt_filter As f
    Where
        tgt.AntoraModule = f.AntoraModule
)