ssis.PackageTask_Dft_Component_tgt - V

type: V ( view ), modify_date: 2021-11-06 12:45:34

RepoObject_guid: B8DCAD7F-F73E-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.packagetask_dft_component_tgt

Columns

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

1

varchar(50)

NOT NULL

2

varchar(200)

NULL

3

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

int

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

int

NULL

varchar(max)

NULL

bit

NULL

bit

NULL

int

NULL

varchar(max)

NULL

varchar(10)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

varchar(max)

NULL

int

NOT NULL

varchar(8000)

NULL

Persistence, History Table

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

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packagetask_dft_component_tgt

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packagetask_dft_component_tgt

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packagetask_dft_component_tgt

Column Reference Diagram

entity_1_1_colref-ssis.packagetask_dft_component_tgt

Indexes

PK_PackageTask_Dft_Component_tgt

idx_PackageTask_Dft_Component_tgt__2

idx_PackageTask_Dft_Component_tgt__3

idx_PackageTask_Dft_Component_tgt__4

Column Details

_

AntoraModule

1

AntoraModule

varchar(50)

NOT NULL

PackageName

2

PackageName

varchar(200)

NULL

Component_refId

3

Component_refId

varchar(max)

NULL

Component_AccessMode

Component_AccessMode

varchar(max)

NULL

Component_AlwaysUseDefaultCodePage

Component_AlwaysUseDefaultCodePage

varchar(max)

NULL

Component_CommandTimeout

Component_CommandTimeout

int

NULL

Component_componentClassID

Component_componentClassID

varchar(max)

NULL

Component_Connection_description

Component_Connection_description

varchar(max)

NULL

Component_Connection_name

Component_Connection_name

varchar(max)

NULL

Component_Connection_refId

Component_Connection_refId

varchar(max)

NULL

Component_connectionManagerID

Component_connectionManagerID

varchar(max)

NULL

Component_connectionManagerRefId

Component_connectionManagerRefId

varchar(max)

NULL

Component_ContactInfo

Component_ContactInfo

varchar(max)

NULL

Component_DefaultCodePage

Component_DefaultCodePage

int

NULL

Component_description

Component_description

varchar(max)

NULL

Component_FastLoadKeepIdentity

Component_FastLoadKeepIdentity

bit

NULL

Component_FastLoadKeepNulls

Component_FastLoadKeepNulls

bit

NULL

Component_FastLoadMaxInsertCommitSize

Component_FastLoadMaxInsertCommitSize

int

NULL

Component_FastLoadOptions

Component_FastLoadOptions

varchar(max)

NULL

Component_IsSortedProperty

Component_IsSortedProperty

varchar(10)

NULL

Component_name

Component_name

varchar(max)

NULL

Component_OpenRowset

Component_OpenRowset

varchar(max)

NULL

Component_OpenRowsetVariable

Component_OpenRowsetVariable

varchar(max)

NULL

Component_ParameterMapping

Component_ParameterMapping

varchar(max)

NULL

Component_SqlCommand

Component_SqlCommand

varchar(max)

NULL

Component_SqlCommandVariable

Component_SqlCommandVariable

varchar(max)

NULL

Component_VariableName

Component_VariableName

varchar(max)

NULL

ControlFlowDetailsRowID

ControlFlowDetailsRowID

int

NOT NULL

TaskPath

TaskPath

varchar(8000)

NULL

sql_modules_definition

ssis.PackageTask_Dft_Component_tgt - V script
CREATE View [ssis].[PackageTask_Dft_Component_tgt]
As
Select
    tgt.AntoraModule
  , tgt.PackageName
  , tgt.Component_refId
  , tgt.Component_name
  , tgt.Component_componentClassID
  , tgt.Component_description
  , tgt.Component_ContactInfo
  , tgt.Component_CommandTimeout
  , tgt.Component_OpenRowset
  , tgt.Component_OpenRowsetVariable
  , tgt.Component_SqlCommand
  , tgt.Component_SqlCommandVariable
  , tgt.Component_DefaultCodePage
  , tgt.Component_AlwaysUseDefaultCodePage
  , tgt.Component_AccessMode
  , tgt.Component_ParameterMapping
  , tgt.Component_FastLoadKeepIdentity
  , tgt.Component_FastLoadKeepNulls
  , tgt.Component_FastLoadOptions
  , tgt.Component_FastLoadMaxInsertCommitSize
  , tgt.Component_VariableName
  , tgt.Component_Connection_refId
  , tgt.Component_connectionManagerID
  , tgt.Component_connectionManagerRefId
  , tgt.Component_Connection_description
  , tgt.Component_Connection_name
  , tgt.Component_IsSortedProperty
  , tgt.TaskPath
  , tgt.ControlFlowDetailsRowID
From
    ssis.PackageTask_Dft_Component As tgt
Where
    Exists
(
    Select
        1
    From
        ssis.AntoraModule_tgt_filter As f
    Where
        tgt.AntoraModule = f.AntoraModule
)