ssis.PackageParameter_src - V

type: V ( view ), modify_date: 2021-11-01 14:17:34

RepoObject_guid: 6064FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.packageparameter_src

Columns

Table 1. Columns of ssis.PackageParameter_src - V
PK Column Name Data Type NULL? ID

1

varchar(50)

NOT NULL

2

varchar(200)

NULL

3

varchar(500)

NULL

varchar(5000)

NULL

varchar(max)

NULL

varchar(1000)

NULL

varchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis.packageparameter_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packageparameter_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packageparameter_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packageparameter_src

Column Reference Diagram

entity_1_1_colref-ssis.packageparameter_src

Indexes

PK_PackageParameter_src

idx_PackageParameter_src__2

idx_PackageParameter_src__3

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

Referenced Columns

PackageName

2

PackageName

varchar(200)

NULL

Description

(left(replace([PackagePath],[ProjectPath]+'\',''),(200)))


Referenced Columns

ParameterName

3

ParameterName

varchar(500)

NULL

ExpressionValue

ExpressionValue

varchar(5000)

NULL

ParameterDataType

ParameterDataType

varchar(max)

NULL

ParameterHexValue

ParameterHexValue

varchar(1000)

NULL

ParameterValue

ParameterValue

varchar(max)

NULL

sql_modules_definition

ssis.PackageParameter_src - V script
CREATE View [ssis].[PackageParameter_src]
As
Select
    p.AntoraModule
  , p.PackageName
  , T2.ParameterName
  , T2.ParameterDataType
  , T2.ParameterValue
  , T2.ExpressionValue
  , T2.ParameterHexValue
From
    ssis.Package_src               As p
    Inner Join
        ssis_t.TblParameter As T2
            On
            p.RowID = T2.RowID