ssis.PackageVariable_tgt - V :: DataHandwerk Docs

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssis.PackageVariable_tgt - V
PK	Column Name	Data Type	NULL?
1	AntoraModule	`varchar(50)`	`NOT NULL`
2	PackageName	`varchar(200)`	`NOT NULL`
3	VariableName	`varchar(500)`	`NOT NULL`
	ExpressionValue	`varchar(5000)`	`NULL`
	VariableDataType	`varchar(max)`	`NULL`
	VariableHexValue	`varchar(1000)`	`NULL`
	VariableValue	`varchar(max)`	`NULL`

Persistence, History Table

persistence source: ssis.PackageVariable_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_PackageVariable_tgt

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

idx_PackageVariable_tgt__2

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

idx_PackageVariable_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

VariableName

3

VariableName

varchar(500)

NOT NULL

Referenced Columns

ExpressionValue

varchar(5000)

NULL

Referenced Columns

VariableDataType

varchar(max)

NULL

Referenced Columns

VariableHexValue

varchar(1000)

NULL

Referenced Columns

VariableValue

varchar(max)

NULL

Referenced Columns

sql_modules_definition

ssis.PackageVariable_tgt - V script

CREATE View [ssis].[PackageVariable_tgt]
As
Select
    tgt.AntoraModule
  , tgt.PackageName
  , tgt.VariableName
  , tgt.VariableDataType
  , tgt.VariableValue
  , tgt.ExpressionValue
  , tgt.VariableHexValue
From
    ssis.PackageVariable As tgt
Where
    Exists
(
    Select
        1
    From
        ssis.AntoraModule_tgt_filter As f
    Where
        tgt.AntoraModule = f.AntoraModule
)