ssis_t.TblTask_Sql_src - V

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

RepoObject_guid: 9064FBE4-113B-EC11-852C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssis_t.tbltask_sql_src

Columns

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

int

NOT NULL

int

NULL

uniqueidentifier

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssis_t.tbltask_sql_src

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssis_t.tbltask_sql_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssis_t.tbltask_sql_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssis_t.tbltask_sql_src

Column Reference Diagram

entity_1_1_colref-ssis_t.tbltask_sql_src

Indexes

idx_TblTask_Sql_src__1

Column Details

_

ControlFlowDetailsRowID

ControlFlowDetailsRowID

int

NOT NULL

RowID

RowID

int

NULL

Referenced Columns

SqlConnection

SqlConnection

uniqueidentifier

NULL

SqlStatementSource

SqlStatementSource

nvarchar(max)

NULL

sql_modules_definition

ssis_t.TblTask_Sql_src - V script
CREATE VIEW [ssis_t].[TblTask_Sql_src]
As
Select
    cf.RowID
  , cf.ControlFlowDetailsRowID
  , SqlConnection      = cfnodes1.x.value (
                                              'declare namespace SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask";
					/SQLTask:SqlTaskData[1]/@SQLTask:Connection'
                                            , 'uniqueidentifier'
                                          )
  , SqlStatementSource = cfnodes1.x.value (
                                              'declare namespace SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask";
					/SQLTask:SqlTaskData[1]/@SQLTask:SqlStatementSource'
                                            , 'nvarchar(max)'
                                          )
From
    ssis_t.TblControlFlow                   As cf
    Cross Apply Cf.SqlTaskQry.nodes ( '.' ) As cfnodes1(x)