ssis_t.TblTask_Dft_Component_inputs_src - V

type: V ( view ), modify_date: 2021-11-07 16:04:09

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

Description

Examples

Entity Diagram

entity-ssis_t.tbltask_dft_component_inputs_src

Columns

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

int

NOT NULL

int

NOT NULL

varchar(100)

NULL

varchar(100)

NULL

bit

NULL

varchar(500)

NULL

varchar(max)

NULL

xml

NULL

varchar(max)

NULL

int

NULL

Foreign Key Diagram

entity_1_1_fk-ssis_t.tbltask_dft_component_inputs_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis_t.tbltask_dft_component_inputs_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis_t.tbltask_dft_component_inputs_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis_t.tbltask_dft_component_inputs_src

Column Reference Diagram

entity_1_1_colref-ssis_t.tbltask_dft_component_inputs_src

Indexes

idx_TblTask_Dft_Component_inputs_src__1

Column Details

_

ControlFlowDetailsRowID

ControlFlowDetailsRowID

int

NOT NULL

DftComponentId

DftComponentId

int

NOT NULL

input_errorOrTruncationOperation

input_errorOrTruncationOperation

varchar(100)

NULL

input_errorRowDisposition

input_errorRowDisposition

varchar(100)

NULL

input_hasSideEffects

input_hasSideEffects

bit

NULL

input_name

input_name

varchar(500)

NULL

input_refId

input_refId

varchar(max)

NULL

nodescontent

nodescontent

xml

NULL

refId

refId

varchar(max)

NULL

RowID

RowID

int

NULL

sql_modules_definition

ssis_t.TblTask_Dft_Component_inputs_src - V script
CREATE View [ssis_t].[TblTask_Dft_Component_inputs_src]
As
Select
    T1.ControlFlowDetailsRowID
  , T1.RowID
  , T1.DftComponentId
  , T1.refId
  , input_refId                            = inputnodes.x.value ( '@refId[1]', 'varchar(max)' )
  , input_errorOrTruncationOperation       = inputnodes.x.value ( '@errorOrTruncationOperation[1]', 'varchar(100)' )
  , input_errorRowDisposition              = inputnodes.x.value ( '@errorRowDisposition[1]', 'varchar(100)' )
  , input_hasSideEffects                   = inputnodes.x.value ( '@hasSideEffects[1]', 'bit' )
  , input_name                             = inputnodes.x.value ( '@name[1]', 'varchar(500)' )
  , nodescontent                           = inputnodes.x.query ( '.' )
From
    ssis_t.TblTask_Dft_Component                    As T1
    Cross Apply T1.inputsQry.nodes ( './inputs/*' ) As inputnodes(x)