ssis.PackageTask_Dft_Component_output_outputColumn_tgt - V

type: V ( view ), modify_date: 2021-11-07 15:26:50

RepoObject_guid: DA51612B-D23F-EC11-852D-A81E8446D5B0

InheritanceType: 13

Description

Examples

Entity Diagram

entity-ssis.packagetask_dft_component_output_outputcolumn_tgt

Columns

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

1

varchar(50)

NOT NULL

2

varchar(200)

NULL

3

varchar(max)

NULL

varchar(100)

NULL

varchar(100)

NULL

varchar(100)

NULL

varchar(max)

NULL

int

NULL

varchar(max)

NULL

varchar(max)

NULL

int

NULL

int

NULL

varchar(max)

NULL

varchar(max)

NULL

int

NOT NULL

bit

NULL

varchar(500)

NULL

varchar(max)

NULL

varchar(8000)

NULL

Persistence, History Table

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

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packagetask_dft_component_output_outputcolumn_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packagetask_dft_component_output_outputcolumn_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packagetask_dft_component_output_outputcolumn_tgt

Column Reference Diagram

entity_1_1_colref-ssis.packagetask_dft_component_output_outputcolumn_tgt

Indexes

PK_PackageTask_Dft_Component_output_outputColumn_tgt

idx_PackageTask_Dft_Component_output_outputColumn_tgt__2

idx_PackageTask_Dft_Component_output_outputColumn_tgt__3

Column Details

_

sql_modules_definition

ssis.PackageTask_Dft_Component_output_outputColumn_tgt - V script
create View [ssis].[PackageTask_Dft_Component_output_outputcolumn_tgt]
As
Select
    tgt.AntoraModule
  , tgt.PackageName
  , tgt.Component_refId
  , tgt.output_refId
  , tgt.output_name
  , tgt.output_isErrorOut
  , tgt.Column_refId
  , tgt.Column_name
  , tgt.Column_dataType
  , tgt.Column_length
  , tgt.Column_precision
  , tgt.Column_scale
  , tgt.Column_errorOrTruncationOperation
  , tgt.Column_errorRowDisposition
  , tgt.Column_externalMetadataColumnId
  , tgt.Column_lineageId
  , tgt.Column_truncationRowDisposition
  , tgt.TaskPath
  , tgt.ControlFlowDetailsRowID
From
    [ssis].[PackageTask_Dft_Component_output_outputcolumn] As tgt
Where
    Exists
(
    Select
        1
    From
        ssis.AntoraModule_tgt_filter As f
    Where
        tgt.AntoraModule = f.AntoraModule
)