ssis.PackageTask_Dft_Component_input_externalMetadataColumn_src - V

type: V ( view ), modify_date: 2021-11-07 14:31:08

RepoObject_guid: 7BCC7FC6-CF3F-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.packagetask_dft_component_input_externalmetadatacolumn_src

Columns

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

1

varchar(50)

NOT NULL

2

varchar(200)

NULL

3

varchar(max)

NULL

varchar(100)

NULL

int

NULL

varchar(max)

NULL

int

NULL

int

NULL

varchar(max)

NULL

int

NOT NULL

bit

NULL

varchar(100)

NULL

varchar(100)

NULL

bit

NULL

varchar(500)

NULL

varchar(max)

NULL

varchar(8000)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis.packagetask_dft_component_input_externalmetadatacolumn_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packagetask_dft_component_input_externalmetadatacolumn_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packagetask_dft_component_input_externalmetadatacolumn_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packagetask_dft_component_input_externalmetadatacolumn_src

Column Reference Diagram

entity_1_1_colref-ssis.packagetask_dft_component_input_externalmetadatacolumn_src

Indexes

PK_PackageTask_Dft_Component_input_externalMetadataColumn_src

idx_PackageTask_Dft_Component_input_externalMetadataColumn_src__2

idx_PackageTask_Dft_Component_input_externalMetadataColumn_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

TaskPath

TaskPath

varchar(8000)

NULL

Referenced Columns

sql_modules_definition

ssis.PackageTask_Dft_Component_input_externalMetadataColumn_src - V script
Create View ssis.PackageTask_Dft_Component_input_externalMetadataColumn_src
As
Select
    p.AntoraModule
  , p.PackageName
  , Component_refId = T3.refId
  , T3.input_refId
  , T3.input_errorOrTruncationOperation
  , T3.input_errorRowDisposition
  , T3.input_hasSideEffects
  , T3.input_name
  , T3.externalMetadataColumns_isused
  , T3.Column_refId
  , T3.Column_name
  , T3.Column_dataType
  , T3.Column_length
  , T3.Column_precision
  , T3.Column_scale
  , T2.TaskPath
  , T3.ControlFlowDetailsRowID
From
    ssis.Package_src                                                   As p
    Inner Join
        ssis_t.TblControlFlow                                          As T2
            On
            p.RowID                    = T2.RowID

    Inner Join
        ssis_t.TblTask_Dft_Component_inputs_externalMetadataColumn_src As T3
            On
            T3.ControlFlowDetailsRowID = T2.ControlFlowDetailsRowID