ssis.PackageTask_Dft_Component_input_externalMetadataColumn_tgt

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssis.PackageTask_Dft_Component_input_externalMetadataColumn_tgt - V
PK	Column Name	Data Type	NULL?
1	AntoraModule	`varchar(50)`	`NOT NULL`
2	PackageName	`varchar(200)`	`NULL`
3	Column_refId	`varchar(max)`	`NULL`
	Column_dataType	`varchar(100)`	`NULL`
	Column_length	`int`	`NULL`
	Column_name	`varchar(max)`	`NULL`
	Column_precision	`int`	`NULL`
	Column_scale	`int`	`NULL`
	Component_refId	`varchar(max)`	`NULL`
	ControlFlowDetailsRowID	`int`	`NOT NULL`
	externalMetadataColumns_isused	`bit`	`NULL`
	input_errorOrTruncationOperation	`varchar(100)`	`NULL`
	input_errorRowDisposition	`varchar(100)`	`NULL`
	input_hasSideEffects	`bit`	`NULL`
	input_name	`varchar(500)`	`NULL`
	input_refId	`varchar(max)`	`NULL`
	TaskPath	`varchar(8000)`	`NULL`

Persistence, History Table

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

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

PK_PackageTask_Dft_Component_input_externalMetadataColumn_tgt

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

idx_PackageTask_Dft_Component_input_externalMetadataColumn_tgt__2

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

idx_PackageTask_Dft_Component_input_externalMetadataColumn_tgt__3

IndexSemanticGroup: no_group
- [column-AntoraModule]; varchar(50)
PK, Unique, Real: 0, 0, 0

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

Referenced Columns

PackageName

2

PackageName

varchar(200)

NULL

Referenced Columns

Column_refId

3

Column_refId

varchar(max)

NULL

Referenced Columns

Column_dataType

varchar(100)

NULL

Referenced Columns

Column_length

int

NULL

Referenced Columns

Column_name

varchar(max)

NULL

Referenced Columns

Column_precision

int

NULL

Referenced Columns

Column_scale

int

NULL

Referenced Columns

Component_refId

varchar(max)

NULL

Referenced Columns

ControlFlowDetailsRowID

int

NOT NULL

Referenced Columns

externalMetadataColumns_isused

bit

NULL

Referenced Columns

input_errorOrTruncationOperation

varchar(100)

NULL

Referenced Columns

input_errorRowDisposition

varchar(100)

NULL

Referenced Columns

input_hasSideEffects

bit

NULL

Referenced Columns

input_name

varchar(500)

NULL

Referenced Columns

input_refId

varchar(max)

NULL

Referenced Columns

TaskPath

varchar(8000)

NULL

Referenced Columns

sql_modules_definition

ssis.PackageTask_Dft_Component_input_externalMetadataColumn_tgt - V script

create View [ssis].[PackageTask_Dft_Component_input_externalMetadataColumn_tgt]
As
Select
    tgt.AntoraModule
  , tgt.PackageName
  , tgt.Component_refId
  , tgt.input_refId
  , tgt.input_errorOrTruncationOperation
  , tgt.input_errorRowDisposition
  , tgt.input_hasSideEffects
  , tgt.input_name
  , tgt.externalMetadataColumns_isused
  , tgt.Column_refId
  , tgt.Column_name
  , tgt.Column_dataType
  , tgt.Column_length
  , tgt.Column_precision
  , tgt.Column_scale
  , tgt.TaskPath
  , tgt.ControlFlowDetailsRowID
From
    ssis.PackageTask_Dft_Component_input_externalMetadataColumn As tgt
Where
    Exists
(
    Select
        1
    From
        ssis.AntoraModule_tgt_filter As f
    Where
        tgt.AntoraModule = f.AntoraModule
)