ssis.PackageTask_Sql_Parameter_tgt - V

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

RepoObject_guid: 6B64FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.packagetask_sql_parameter_tgt

Columns

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

1

varchar(50)

NOT NULL

2

varchar(200)

NOT NULL

3

varchar(8000)

NOT NULL

4

varchar(1000)

NOT NULL

int

NOT NULL

varchar(1000)

NULL

varchar(1000)

NULL

Persistence, History Table

  • persistence source: ssis.PackageTask_Sql_Parameter_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

entity_1_1_fk-ssis.packagetask_sql_parameter_tgt

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packagetask_sql_parameter_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packagetask_sql_parameter_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packagetask_sql_parameter_tgt

Column Reference Diagram

entity_1_1_colref-ssis.packagetask_sql_parameter_tgt

Indexes

PK_PackageTask_Sql_Parameter_tgt

idx_PackageTask_Sql_Parameter_tgt__2

idx_PackageTask_Sql_Parameter_tgt__3

idx_PackageTask_Sql_Parameter_tgt__4

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

PackageName

2

PackageName

varchar(200)

NOT NULL

TaskPath

3

TaskPath

varchar(8000)

NOT NULL

ParameterBindingSequence

4

ParameterBindingSequence

varchar(1000)

NOT NULL

ControlFlowDetailsRowID

ControlFlowDetailsRowID

int

NOT NULL

ParameterBindingParameterName

ParameterBindingParameterName

varchar(1000)

NULL

ResultSetParameterName

ResultSetParameterName

varchar(1000)

NULL

sql_modules_definition

ssis.PackageTask_Sql_Parameter_tgt - V script
CREATE View [ssis].[PackageTask_Sql_Parameter_tgt]
As
Select
    tgt.AntoraModule
  , tgt.PackageName
  , tgt.TaskPath
  , tgt.ParameterBindingSequence
  , tgt.ResultSetParameterName
  , tgt.ParameterBindingParameterName
  , tgt.ControlFlowDetailsRowID
From
    ssis.PackageTask_Sql_Parameter As tgt
Where
    Exists
(
    Select
        1
    From
        ssis.AntoraModule_tgt_filter As f
    Where
        tgt.AntoraModule = f.AntoraModule
)