ssis_t.TblTask_Script_src - V
type: V ( view ), modify_date: 2021-11-01 13:46:40
RepoObject_guid: 8D64FBE4-113B-EC11-852C-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
Indexes
idx_TblTask_Script_src__1
-
IndexSemanticGroup: no_group
-
PK, Unique, Real: 0, 0, 0
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)