ssis.PackageVariable_src - V
type: V ( view ), modify_date: 2021-11-01 14:30:02
RepoObject_guid: 6F64FBE4-113B-EC11-852C-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
3 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_PackageVariable_src
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
[column-VariableName]; varchar(500)
-
-
PK, Unique, Real: 1, 1, 0
idx_PackageVariable_src__2
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
[column-PackageName]; varchar(200)
-
-
PK, Unique, Real: 0, 0, 0
idx_PackageVariable_src__3
-
IndexSemanticGroup: no_group
-
[column-AntoraModule]; varchar(50)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
PackageName
2 |
PackageName |
|
|
Description
(left(replace([PackagePath],[ProjectPath]+'\',''),(200)))
Referenced Columns
Referencing Columns
sql_modules_definition
ssis.PackageVariable_src - V script
CREATE View ssis.PackageVariable_src
As
Select
p.AntoraModule
, p.PackageName
, T2.VariableName
, T2.VariableDataType
, T2.VariableValue
, T2.ExpressionValue
, T2.VariableHexValue
From
ssis.Package_src As p
Inner Join
ssis_t.TblVariable As T2
On
p.RowID = T2.RowID