ssis_t.TblTask_Script_src - V

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

RepoObject_guid: 8D64FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis_t.tbltask_script_src

Columns

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

int

NOT NULL

int

NULL

varchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis_t.tbltask_script_src

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis_t.tbltask_script_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis_t.tbltask_script_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis_t.tbltask_script_src

Column Reference Diagram

entity_1_1_colref-ssis_t.tbltask_script_src

Indexes

idx_TblTask_Script_src__1

Column Details

_

ControlFlowDetailsRowID

ControlFlowDetailsRowID

int

NOT NULL

RowID

RowID

int

NULL

Referenced Columns

Script

Script

varchar(max)

NULL

sql_modules_definition

ssis_t.TblTask_Script_src - V script
CREATE VIEW [ssis_t].[TblTask_Script_src]
As
Select
    cf.RowID
  , cf.ControlFlowDetailsRowID
  , Script = cfnodes1.x.value ( './ProjectItem[@Name=''ScriptMain.cs''][1]', 'varchar(max)' )
From
    ssis_t.TblControlFlow               As cf
    Cross Apply Cf.ScriptTaskQry.nodes ( '.' ) As cfnodes1(x)