ssis.PackageTask_Dft_Component_output_outputcolumn_src - V

type: V ( view ), modify_date: 2021-11-07 14:28:41

RepoObject_guid: 78CC7FC6-CF3F-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis.packagetask_dft_component_output_outputcolumn_src

Columns

Table 1. Columns of ssis.PackageTask_Dft_Component_output_outputcolumn_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

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

Foreign Key Diagram

entity_1_1_fk-ssis.packagetask_dft_component_output_outputcolumn_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis.packagetask_dft_component_output_outputcolumn_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis.packagetask_dft_component_output_outputcolumn_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis.packagetask_dft_component_output_outputcolumn_src

Column Reference Diagram

entity_1_1_colref-ssis.packagetask_dft_component_output_outputcolumn_src

Indexes

PK_PackageTask_Dft_Component_output_outputcolumn_src

idx_PackageTask_Dft_Component_output_outputcolumn_src__2

idx_PackageTask_Dft_Component_output_outputcolumn_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

Column_errorOrTruncationOperation

Column_errorOrTruncationOperation

varchar(100)

NULL

Column_errorRowDisposition

Column_errorRowDisposition

varchar(100)

NULL

Column_externalMetadataColumnId

Column_externalMetadataColumnId

varchar(max)

NULL

Column_lineageId

Column_lineageId

varchar(max)

NULL

Column_truncationRowDisposition

Column_truncationRowDisposition

varchar(max)

NULL

Component_refId

Component_refId

varchar(max)

NULL

TaskPath

TaskPath

varchar(8000)

NULL

Referenced Columns

sql_modules_definition

ssis.PackageTask_Dft_Component_output_outputcolumn_src - V script
CREATE View [ssis].[PackageTask_Dft_Component_output_outputColumn_src]
As
Select
    p.AntoraModule
  , p.PackageName
  , Component_refId = T3.refId
  , T3.output_refId
  , T3.output_name
  , T3.output_isErrorOut
  , T3.Column_refId
  , T3.Column_name
  , T3.Column_dataType
  , T3.Column_length
  , T3.Column_precision
  , T3.Column_scale
  , T3.Column_errorOrTruncationOperation
  , T3.Column_errorRowDisposition
  , T3.Column_externalMetadataColumnId
  , T3.Column_lineageId
  , T3.Column_truncationRowDisposition
  , 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_outputs_outputColumn_src As T3
            On
            T3.ControlFlowDetailsRowID = T2.ControlFlowDetailsRowID