ssis_t.TblTask_Dft_SrcDest_src - V

type: V ( view ), modify_date: 2021-11-01 13:46:40

RepoObject_guid: 8864FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis_t.tbltask_dft_srcdest_src

Columns

Table 1. Columns of ssis_t.TblTask_Dft_SrcDest_src - V
PK Column Name Data Type NULL? ID

int

NOT NULL

varchar(9)

NOT NULL

varchar(max)

NULL

int

NULL

varchar(200)

NULL

varchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis_t.tbltask_dft_srcdest_src

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis_t.tbltask_dft_srcdest_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis_t.tbltask_dft_srcdest_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis_t.tbltask_dft_srcdest_src

Column Reference Diagram

entity_1_1_colref-ssis_t.tbltask_dft_srcdest_src

Column Details

_

DataFlowDetailsRowID

DataFlowDetailsRowID

int

NOT NULL

DataSource

DataSource

varchar(9)

NOT NULL

DestinationColumn

DestinationColumn

varchar(max)

NULL

RowID

RowID

int

NULL

SortKeyPosition

SortKeyPosition

varchar(200)

NULL

SourceColumn

SourceColumn

varchar(max)

NULL

sql_modules_definition

ssis_t.TblTask_Dft_SrcDest_src - V script
CREATE VIEW [ssis_t].[TblTask_Dft_SrcDest_src]
As
Select
    pkglvl.RowID
  , pkglvl.DataFlowDetailsRowID
  , SourceColumn      = lineage.x.value ( './@lineageId[1]', 'varchar(max)' )
  , DestinationColumn = Coalesce (
                                     lineage.x.value ( './@name[1]', 'varchar(max)' )
                                   , lineage.x.value ( './@externalMetadataColumnId[1]', 'varchar(max)' )
                                   , lineage.x.value ( './@refId[1]', 'varchar(max)' )
                                 )
  , SortKeyPosition   = lineage.x.value ( './@sortKeyPosition[1]', 'varchar(200)' )
  , DataSource        = 'InputQry'
From
    ssis_t.TblTask_Dft_Details                    As pkglvl
    Cross Apply pkglvl.InputQry.nodes ( './*' ) As lineage(x)
Union All
Select
    pkglvl.RowID
  , pkglvl.DataFlowDetailsRowID
  , SourceColumn      = lineage.x.value ( './@lineageId[1]', 'varchar(max)' )
  , DestinationColumn = Coalesce (
                                     lineage.x.value ( './@name[1]', 'varchar(max)' )
                                   , lineage.x.value ( './@externalMetadataColumnId[1]', 'varchar(max)' )
                                   , lineage.x.value ( './@refId[1]', 'varchar(max)' )
                                 )
  , SortKeyPosition   = lineage.x.value ( './@sortKeyPosition[1]', 'varchar(200)' )
  , DataSource        = 'OutputQry'
From
    ssis_t.TblTask_Dft_Details                     As pkglvl
    Cross Apply pkglvl.OutputQry.nodes ( './*' ) As lineage(x)