ssis.ProjectConnection_tgt - V :: DataHandwerk Docs

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssis.ProjectConnection_tgt - V
PK	Column Name	Data Type	NULL?
1	AntoraModule	`varchar(50)`	`NOT NULL`
2	ConnectionManagerID	`uniqueidentifier`	`NOT NULL`
	ConnectionManagerName	`varchar(max)`	`NOT NULL`
	ConnectionManagerType	`varchar(max)`	`NULL`
	ConnectionPath	`varchar(8000)`	`NOT NULL`
	ConnectionString	`nvarchar(max)`	`NULL`
	ExpressionValue	`nvarchar(max)`	`NULL`

Persistence, History Table

persistence source: ssis.ProjectConnection_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_ProjectConnection_tgt

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

idx_ProjectConnection_tgt__2

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

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

Referenced Columns

ConnectionManagerID

2

ConnectionManagerID

uniqueidentifier

NOT NULL

Referenced Columns

ConnectionManagerName

varchar(max)

NOT NULL

Referenced Columns

ConnectionManagerType

varchar(max)

NULL

Referenced Columns

ConnectionPath

varchar(8000)

NOT NULL

Referenced Columns

ConnectionString

nvarchar(max)

NULL

Referenced Columns

ExpressionValue

nvarchar(max)

NULL

Referenced Columns

sql_modules_definition

ssis.ProjectConnection_tgt - V script

CREATE View ssis.ProjectConnection_tgt
As
Select
    tgt.AntoraModule
  , tgt.ConnectionManagerID
  , tgt.ConnectionManagerName AS ConnectionManagerName
  , tgt.ConnectionManagerType
  , tgt.ConnectionPath
  , tgt.ConnectionString
  , tgt.ExpressionValue
From
    ssis.ProjectConnection As tgt
Where
    Exists
(
    Select
        1
    From
        ssis.AntoraModule_tgt_filter As f
    Where
        tgt.AntoraModule = f.AntoraModule
)