ssis_t.TblTask_Dft_Component_outputs_src - V
type: V ( view ), modify_date: 2021-11-07 11:59:59
RepoObject_guid: 74CC7FC6-CF3F-EC11-852D-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_TblTask_Dft_Component_outputs_src__1
-
IndexSemanticGroup: no_group
-
PK, Unique, Real: 0, 0, 0
Column Details
_
sql_modules_definition
ssis_t.TblTask_Dft_Component_outputs_src - V script
create View [ssis_t].[TblTask_Dft_Component_outputs_src]
As
Select
T1.ControlFlowDetailsRowID
, T1.RowID
, T1.DftComponentId
, T1.refId
, output_refId = outputnodes.x.value ( '@refId[1]', 'varchar(max)' )
, output_name = outputnodes.x.value ( '@name[1]', 'varchar(500)' )
, output_isErrorOut = outputnodes.x.value ( '@isErrorOut[1]', 'bit' )
, nodescontent = outputnodes.x.query ( '.' )
From
ssis_t.TblTask_Dft_Component As T1
Cross Apply T1.outputsQry.nodes ( './outputs/*' ) As outputnodes(x)