ssis.PackageVariable - U :: DataHandwerk Docs

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssis.PackageVariable - U
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`

Foreign Key Diagram

References

Referenced Objects

ssis.PackageVariable_tgt - V

Referencing Objects

docs.ssis_VariableList - V

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

PK_PackageVariable

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

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

Referencing Columns

PackageName

2

PackageName

varchar(200)

NOT NULL

Referencing Columns

VariableName

3

VariableName

varchar(500)

NOT NULL

Referencing Columns

ssis.PackageVariable_tgt.VariableName

ExpressionValue

varchar(5000)

NULL

Referencing Columns

ssis.PackageVariable_tgt.ExpressionValue

VariableDataType

varchar(max)

NULL

Referencing Columns

ssis.PackageVariable_tgt.VariableDataType

VariableHexValue

varchar(1000)

NULL

Referencing Columns

ssis.PackageVariable_tgt.VariableHexValue

VariableValue

varchar(max)

NULL

Referencing Columns

ssis.PackageVariable_tgt.VariableValue