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
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
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)